Skip to content

Logical Functions

AND Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE.
FALSE Returns the value FALSE. May be typed directly into the cell as “FALSE”.
IF Returns a value if one condition is TRUE and returns another value if the condition is FALSE.
NOT Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE.
OR Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE.
TRUE Returns the value TRUE. May be typed directly into the cell as “TRUE”.