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.
- Click where you want to add the AND, OR, or NOT function within an existing logical function.
- Enter an AND, OR, or NOT function with the arguments you want to test for.
You may find it helpful to open the Insert Function dialog box to help guide you through adding the AND, OR, or NOT function.
- Click the Enter button or press the Enter key.
The formula is recalculated to include the additional condition.