Microsoft® Office Excel 2003 Inside Out

Creating Conditional Tests

A conditional test formula compares two numbers, functions, formulas, labels, or logical values. Conditional tests can be used to flag values that fall below or above 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 ...