# The Excel OR Function

Related Function:
AND Function

## Function Description

The Excel OR function tests a number of supplied conditions and returns either:

• TRUE if ANY of the conditions evaluate to TRUE
or
• FALSE otherwise (i.e. if ALL of the conditions evaluate to FALSE).

The syntax of the function is:

OR( logical_test1, [logical_test2], ... )

where the logical_test arguments are one or more conditions that evaluate to either TRUE or FALSE.

Notes:

• In current versions of Excel (Excel 2007 and later), you can enter up to 255 logical_test arguments to the Excel Or function. However, in Excel 2003, the function can only handle up to 30 arguments.
• If the logical_test arguments evaluate to numbers, instead of logical values, the value zero is treated as FALSE and all non-zero values are treated as TRUE.

## Excel Or Function Examples

The following spreadsheet shows three examples of the Excel Or function.

Formulas:
ABC
1510=OR( A1>0, A1<B1 )
2510=OR( A2>0, A2>B2, B2>12 )
3510=OR( A3<0, A3>B3, B3>12 )
Results:
ABC
1510TRUE
2510TRUE
3510FALSE

In the above examples:

• the function in cell C1 evaluates to TRUE, as BOTH of the supplied conditions are TRUE;
• the function in cell C2 evaluates to TRUE, as the first condition, A2>0 evaluates to TRUE;
• the function in cell C3 evaluates to FALSE, as ALL of the supplied conditions are FALSE.

For further examples of the Excel Or function, see the Microsoft Office website.

## Excel Or Function Error

The most common error from the Excel Or Function is the #VALUE! error:

Common Error
 #VALUE! - Occurs if any of the supplied logical_test cannot be interpreted as numeric or logical values.