OR

The OR function returns TRUE if at least one of the arguments is TRUE and returns FALSE when all the arguments evaluate to FALSE.

Syntax

or(logical_test1,[logical_test2],...)

Arguments

logical_test1 – The first condition to be evaluated. This is a required argument.

logical_test2,.. – The additional conditions that are to be evaluated. These are optional arguments.

Return value

Either True or False

Example

if(or(Region == "West", Region =="East"), 25, 30)

Will return 25 if the region is West or East; otherwise, returns 30

Excel equivalent

OR

Last updated