Use the OR function to check cells for text - Logical Functions - Microsoft Excel Tutorials

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

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=dgoemyel0fw

  Hope You Like This Tutorial - Give Comments