MS-Excel / Functions and Formula

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 function is used for this task. The function returns TRUE if any argument is TRUE and FALSE if all arguments are FALSE.

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

Please note that the formula must have an absolute reference to cell C1. Also, columns B and C are formatted with the Currency style, which is available by clicking on the $ button on the Formatting toolbar.

[Previous] [Contents] [Next]

In this tutorial:

  1. Logical Functions in Excel
  2. Use the AND function to compare two columns
  3. Use the OR function to check cells for numbers
  4. Combine IF with AND to check several conditions
  5. Use the IF function to calculate with different tax rates