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
Last updated