Formulas and Functions

Chapter 7 Logical and Information Functions 165
OR
The OR function returns TRUE if any argument is true; otherwise it returns FALSE.
OR(any-expression, any-expression…)
 any-expression: An expression to be tested. any-expression can contain anything as
long as the expression can be evaluated as a Boolean. If the expression evaluates to a
number, 0 is considered to be FALSE, and any other number is considered to be TRUE.
 any-expression…:Optionally include one or more additional expressions to be tested.
Usage Notes
The OR function is equivalent to the logical disjunction or inclusive disjunction Â
used in mathematics or logic. It rst evaluates each expression. If any of the given
expressions evaluate to TRUE, the OR function returns TRUE; otherwise FALSE.
If an expression is numeric, a value of 0 is interpreted as FALSE and any nonzero Â
value is interpreted as TRUE.
OR is often used with the IF function when more than one condition must be Â
considered.
Examples
=OR(A1+A2<100, B1+B2<100) returns FALSE if the sums of the indicated cells are both greater than
or equal to 100, and TRUE if at least one of the sums is less than 100.
=OR(5, 0, 6) returns TRUE because at least one argument is not zero.
Related Topics
For related functions and additional information, see:
“AND” on page 156
“IF” on page 15 8
“NOT” on page 164
“Specifying Conditions and Using Wildcards” on page 360
“Adding Comments Based on Cell Contents” on page 358
“Using Logical and Information Functions Together” on page 358
“Listing of Logical and Information Functions” on page 15 5
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41