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

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