OR

Evaluates multiple conditions and returns TRUE if at least one condition is satisfied.

The OR function returns TRUE if at least one of the specified conditions is TRUE. It returns FALSE only when all conditions evaluate to FALSE. It is commonly used with IF and other conditional functions to evaluate multiple criteria.

Syntax#

OR(logical_test1, [logical_test2], ...)

Arguments#

• logical_test1: The first condition to evaluate.
• logical_test2, ... (Optional): Additional conditions to evaluate.

Return value#

Returns TRUE if any condition is met; otherwise, returns FALSE.

Example#

IF(OR(Sub Region == "APAC", Sub Category == "Juices"), 52640000, 0)

In this example, the OR function is used within an IF statement to assign values to the 2027 Actuals Plan. The function evaluates whether either condition is met: Sub Region is APAC or Sub Category is Juices. If at least one condition is TRUE, the formula returns 52.64 million; otherwise, it returns 0.

Excel equivalent#

OR