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

A worksheet contains several values in column A. Each row has to be evaluated based on certain criteria in column A. The OR function 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.

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

USE THE OR FUNCTION TO CHECK CELLS FOR NUMBERS 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 numbers using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel