Excel: Work Smarter (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

More Logical Functions Conditional Logic: OR The OR function answers True if any of the conditions are true. Select: cell A5. Go to Formula ->Logical ->OR. Logical1: A2>3 Logical2: A3="wet"   The formula in this example is: =OR(A2>3,A3="wet")   Try This: The NOT Function Question: Is cell A3 greater than 3? The NOT function returns the opposite answer: changes FALSE to TRUE or vice versa.   The formula in this example is: =NOT(A2>3)