14.5 Using Excel Logical Functions
In this section, we will look at some of Excel’s logical functions. These are functions that allow
you to test various conditions when programming formulas to analyze data. Excel’s logical func-
tions and their descriptions are shown in Table 14.6.
Excel also offers relational or comparison operators that allow for testing of relative
magnitude of various arguments. These relational operators are shown in Table 14.7. We
will use Example 14.5 to demonstrate the use of Excel’s logical functions and relational
operators.
14.5 Using Excel Logical Functions 433
TABLE 14.6 Excel’s Logical Functions
Logical Functions Description of the Function
AND(logic1, logic2, logic3,.. .) Returns true if all arguments are true and returns false
if any of the arguments are false.
False( ) Returns the logical value false.
IF(logical test, value_if_true, It first evaluates the logical test; if true, then it returns
value_if_false) the value_if_true; if the evaluation of the logical
test deems false, then it returns the value_if_false
value.
NOT(logical) Reverses the logic of its argument; returns true for a false
argument and false for the true argument.
OR(logical1, logical2,.. .) Returns TRUE if any argument is true and returns
FALSE if all arguments are false.
TRUE( ) Returns the logical value TRUE.
TABLE 14.7 Excel’s Relational Operators and Their Descriptions
Relational Operator Description
Less than
Less than or equal to
Equal to
Greater than
Greater than or equal to
Not equal to
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀