Microsoft Excel Functions & Formulas

Use the OR function to check cells for text

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

be checked for the words “new” or “actual” in column A. The OR

function is used for this task. The function returns TRUE if either

argument is true and FALSE if the arguments are not true.

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

4

To use the OR function to check for two or more criteria:

1. Enter in range A2:A11 words like “new,” “actual,” and

“old.”

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

=OR(A2="New",A2="actual").

3. Press <Ctrl+Enter>.

42

Chapter 2

Figure 2-3