How to use the OR function

The OR statement in Excel is a logical function that allows you to test multiple conditions at once and returns TRUE if any of the conditions are true, and returns FALSE if all of the conditions are false.

Where logical1, logical2,… are one or more conditions that you want to evaluate.

For example, suppose you have a dataset containing sales figures for different products, and you want to find out which products have a price of more than 250.00 or where the quantity is more than 150 units. 

You can also use the OR function as a part of a larger formula or nested within other functions to perform more complex logical evaluations.