Excel Except Function

Excel Except Function

Users of Excel will all eventually need to do an Excel except function i.e. where a cell does not equal to a certain range of numbers for example.

Excel does not have an Except function so we need to use another function to achieve the same result. In this case we need to use the OR function (click here to see a video clip of the OR function).

So if we are interested whether X is a number outside of the range of 10 and 20, we could ask Excel if X is bigger than 20 OR less than 10 (in Excel terms this would be =OR(X>20,X<10). This will result in a True or False, which we can then use in other formula.

Be careful that you get the signs correct and that you use the OR function. If you accidentally say =AND(X>20,X<10) you will always get a false as no number can be bigger than 20 AND smaller than 10.