Microsoft Excel Functions & Formulas

Use the OR function to check cells for numbers

A worksheet contains several values in column A. Each row has to

be evaluated based on certain criteria in column A. The OR func-

tion is used for this task. The function returns TRUE if any

argument is TRUE and FALSE if all arguments are FALSE.

Note: Up to 30 conditions can be used in one formula.

4

To check for two or more criteria:

1. Enter in range A2:A12 values from –43 to 100.

2. Select cells B2:B12 and type the following formula:

=OR(A2=1,A2>=99,A2<0).

3. Press <Ctrl+Enter>.

Logical Functions 43

2

Figure 2-4