Engineering Fundamentals: An Introduction to Engineering, 4th ed.c

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).

圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀