Advanced Excel Logical - OR Function

Description

The OR function returns a TRUE if any argument is TRUE and returns FALSE if all arguments are FALSE.

Syntax

OR (logical1, [logical2], ...)

Arguments

Argument Description Required/ Optional
logical1

1 to 255 conditions you want to test that can be either TRUE or FALSE.

1 to 255 conditions you want to test that can be either TRUE or FALSE.

 Required
logical2, … Optional

Notes

  • The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.

  • If any of the supplied logical_test arguments are text values, OR returns the #VALUE! error value.

  • If an array or reference argument contains text or empty cells, those values are ignored.

  • If the specified range contains no logical values, OR returns the #VALUE! error value.

  • If the logical_tests return numbers, instead of logical values, zero is treated as the logical value FALSE and all non-zero numbers are treated as the logical value TRUE.

  • You can use an OR array formula to see if a value occurs in an array. To enter an array formula, press CTRL+SHIFT+ENTER

  • Common functions used with the OR function include the IF function, AND function, and NOT function.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

OR Function
advanced_excel_logical_functions.htm
Advertisements