OR

The OR formula is used to perform a logical test and return TRUE if any of the tests are true, and FALSE if all of the tests are false. To use the OR formula, select the cell where you want the result to appear and enter “=OR(” followed by the logical tests separated by commas. For example, “=OR(A1>5,A2<10)" would return TRUE if the value in cell A1 is greater than 5 or the value in cell A2 is less than 10, and FALSE only if neither of those conditions is true. Example:

Return TRUE if the value in cell A1 is greater than 5 or the value in cell A2 is less than 10: =OR(A1>5,A2<10).