XOR

Evaluates multiple conditions and returns TRUE only if exactly one or an odd number of conditions are met.

The XOR (Exclusive OR) function returns TRUE if exactly one or an odd number of the specified conditions is TRUE. Otherwise, it returns FALSE. It is commonly used with IF and other logical functions to evaluate mutually exclusive conditions.

Syntax

XOR(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(XOR([Region]=="United States",[Category]=="Beverages"),30500000,0)

In this example, values are assigned to the 2027 Plan using the XOR function within an IF statement. The formula returns 30.5m when either the Region is 'United States' or the Category is 'Beverages', but not both. It returns 0 if both conditions are TRUE or both are FALSE.

Applying XOR function

Excel equivalent

XOR