The OR function can be useful when combined with other functions like IF. The simple way to think about the OR function is that you pass one or more arguments (logical tests or conditions) to the function and if any of the arguments evaluate to TRUE, then the OR function returns TRUE. If none of the conditions evaluate to TRUE, then the OR function returns FALSE. So, it's a logical test that can compare up to 255 conditions.

OR takes 1 required argument and 254 optional arguments:

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

#1)
Using the OR function:
#2)
The arguments for the OR function are:
Argument Required? Description
logical1 Required The first condition that you want to test that can evaluate to either TRUE or FALSE.
logical2, ... Optional Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

Summary

The OR function checks to see if any of the tested conditions are true.
comments powered by Disqus