You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one. Visit our page about the OR function for many more examples. Microsoft Excel provides 4 logical functions to work with the logical values.
They help deal with different situations accordingly.
For example take a look at the NOT function in cell D2 below. As an example in the. Excel Logic the IF Function Comparison Operators You can use comparison operators to compare two numbers functions formulas or labels and return either true or false. Excel logical functions - overview.