Articles with the tag:
Articles with the tag:
Try in the cloud
Try in the cloud

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.


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


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.


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.

OR Function: FALSE

If we change the A1 value from 12 to 2, the function returns TRUE:

OR Function: TRUE

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action