USE THE OR FUNCTION TO CHECK CELLS FOR TEXT USING MICROSOFT EXCEL

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

USE THE OR FUNCTION TO CHECK CELLS FOR TEXT USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, OR Function in Excel, Use the OR function to check cells for text using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel