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