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. Required.

logical_test2, ... - Additional conditions to evaluate. Optional.

Return value

Either TRUE or FALSE.

Example

IF(OR([Region]=="United States",[Sub Category]=="Juices"),30500000,0)

In this example, values are assigned to the 2027 Plan using the OR function within an IF statement. The formula returns 30.5m for records where the Region is 'United States' or the Sub Category is 'Juices', and 0 for all other records.

Applying OR function

Excel equivalent

OR