If you're working with Excel's logical functions, like the IF function, sometimes you may need to test against multiple conditions instead of just one. For example, you could check to see if an order total is above $2000 OR is for Paris. Excel has several logical functions you can use as nested functions for the Logical Test.
The AND function returns true if all the arguments evaluate to true. Example: The order total is greater than $2000 AND is for Paris.
The OR function returns true if any of the arguments evaluate to true. Example: The order total is greater than $2000 OR is for Paris.
The NOT function returns the reverse logic of its argument. Example: The order is NOT for Paris.