OR()

Syntax. OR(logical1,logical2,...)

Definition. This function returns the logical value TRUE if at least one of the arguments is true. The OR() function returns the logical value FALSE only if all arguments are false.

Arguments

  • logical1,logical2,... Up to 30 (and in Excel 2007 and Excel 2010 up to 255) logical values or conditions that can be evaluated to logical values (TRUE or FALSE)

Background. If you use arguments other than references and text, the OR() function returns the #VALUE! error. Except for the value of zero, all numbers are interpreted as TRUE. If an argument is omitted, as in

=OR(TRUE)

FALSE is returned.

Arguments from references or arrays should evaluate to logical values (TRUE or FALSE). There are exceptions: If at least one argument ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.

Start your free trial