Table of Contents
The Excel OR function tests whether any arguments are TRUE, and returns TRUE if at least one argument is TRUE. If all arguments are FALSE the OR function will return FALSE.
The OR function is an Excel logical function.
=OR(logical1, [logical2], [logical3], …)
logical1 = a logical statement to be tested that can either be TRUE or FALSE and can be logical values, arrays, or references
logical2, logical3, … = [optional] a logical statement to be tested that can either be TRUE or FALSE and can be logical values, arrays, or references
The OR formula will return a result of TRUE or FALSE. If at least one argument is TRUE then TRUE will be returned however if all arguments are FALSE then FALSE will be returned.
In the example above the OR formulas in column H test whether the order totals in column F are greater than 1000 or if the sales representative is “Jones”. If either logical statement is TRUE, then TRUE is returned.
Because the value in cell C6 is “Jones” the OR formula returns TRUE, even thought the value in F6 is not greater than 1000.