OR Function
The OR function is one of the logical functions. It is used to check if the logical value you enter is TRUE or FALSE. The function returns FALSE if all the arguments are FALSE.
Syntax
OR(logical1, [logical2], ...)
The OR function has the following arguments:
Argument |
Description |
logical1/2/n |
A condition that you want to check if it is TRUE or FALSE |
Notes
You can enter up to 255 logical values.
How to apply the OR function.
The function returns TRUE if at least one of the argument is TRUE.
Examples
There are three arguments: logical1 = A1<10, logical2 = 34<10, logical3 = 50<10, where A1 is 12. All these logical expressions are FALSE. So the function returns FALSE.
If we change the A1 value from 12 to 2, the function returns TRUE:
Return to previous page