Name
OR
Synopsis
Use
OR to look at multiple conditions and
return a logical value of TRUE
if at least one of
the conditions is true. If all of the conditions are false the
function returns a value of FALSE
.
To Calculate
=OR(Logical1
,Logical2
, ...)
-
Logical1, Logical2, ...
There must be between 1 and 30 logical arguments specified. Each argument must evaluate to a value of either
TRUE
orFALSE
. For example,A>B
.
Example
Figure 19-1 illustrates how OR can be used to
compare two logical conditions and return a value. The example looks
at two logical statements that state the numeric value in column A or
B is less than 5. If at least one of the statements is true the
function returns a value of TRUE
. You can compare
this to the results of AND which returns a value of
TRUE
only if all conditions are true.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.