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:

ArgumentDescription
logical1/2/nA 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 arguments 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.

OR Function: FALSE

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

OR Function: TRUE

Host ONLYOFFICE Docs on your own server or use it in the cloud

Article with the tag:
Browse all tags