This chapter explains how to use the logical functions such as NOT(), AND(), and OR() in Microsoft Excel. Table 9-1 lists all the logical functions. Other functions, such as TRUE() and FALSE(), are less frequently used. All of these functions return logical values or use them as an integral part of the function. The IF() function evaluates logical expressions and implements appropriate branches. Comparison operators (=, <, >, <=, >=, and <>) are important when evaluating arguments. The IFERROR() function was introduced in Excel 2007.
Table 9-1. Overview of the Logical Functions
Function | Description |
---|---|
AND() | Returns the logical value |
FALSE() | Returns the logical value |
IF() | Calculates alternatives (using then and else) corresponding to the logical results of a condition evaluation |
IFERROR() | Calculates a specified output if an expression contains an error or returns the result of the expression |
NOT() | Returns the opposite of the logical value specified in the parentheses |
OR() | Returns the logical value |
TRUE() | Returns the logical value |
3.144.113.163