Logical Functions
| AND(logical1,logical2,…) | Returns TRUE if all of its arguments are TRUE. |
| FALSE( ) | Returns the logical value FALSE. |
| IF(logical_test,value_if_true,value_if_false) | Specifies a logical test to perform and the value to return based on a TRUE or FALSE result. |
| NOT(logical) | Reverses the logic of its argument. |
| OR(logical1,logical2,…) | Returns TRUE if any argument is TRUE. |
| TRUE( ) | Returns the logical value TRUE. |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
