Home » Excel-Built-In-Functions » Excel-Or-Function

Basic Description

The Excel OR function tests a number of user-defined conditions and returns a result of:

• TRUE if ANY of the conditions evaluate to TRUE

OR

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

The format of the OR function is:


where Logical_test1, Logical_test2, ... are user-defined conditions

Examples

The following examples show the OR function applied to a number of different conditions. The format of the functions are shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.


In the examples above,

• 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, is TRUE
  
  
• the function in cell C3 evaluates to FALSE, as ALL of the supplied conditions are FALSE