## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

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

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required