2007 Microsoft® Office System Inside Out

Creating Conditional Tests

A conditional test formula compares two numbers, functions, formulas, labels, or logical values. You can use conditional tests to flag values that fall outside a given threshold, for example. You can use simple mathematical and logical operators to construct logical formulas, or you can use an assortment of built-in functions. For information about using conditional test functions, see "Understanding Logical Functions".

Each of the following formulas performs a rudimentary conditional test:

=A1>A2
=5−3<5*2
=AVERAGE(B1:B6)=SUM(6,7,8)
=C2="Female"
=COUNT(A1:A10)=COUNT(B1:B10)
=LEN(A1)=10

Every conditional test must include at least one logical operator, which defines the relationship between elements of the conditional test. ...