• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

### Logical Functions Overview

Logical functions test cells and ranges and return a logical result in the form of text (True or False) or numbers (1 or 0). A logical function operates under a logical test. For example, if you want to apply a simple addition based on whether a cell has a number in it, you could use an IF function to test the cell and then apply the simple addition if the logical result is true. This chapter covers the functions in Table 12.1 that appear in bold.

##### Table 12.1. Logical Functions
FunctionSyntaxDescription
AND=AND(logical1,logical2,...)Returns TRUE if all of the arguments are true in the formula, and FALSE if one or more are false.
FALSE=FALSE()Returns the value FALSE. No arguments are associated with this function.
IF=IF(logical_test,value_if_true,value_if_false)Returns a value or result if one condition is TRUE, and returns another value or result if the condition is FALSE.
NOT=NOT(logical)Returns the reverse value of its arguments. If FALSE returns TRUE, if TRUE returns FALSE.
OR=OR(logical1,logical2,...)Returns FALSE if all arguments are false, and TRUE if any argument is true.
TRUE=TRUE()Returns the value TRUE. No arguments are associated with this function.

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint