XOR
Returns a logical exclusive OR of all arguments
Syntax
XOR(logical1, [logical2], ...)
Parameters
- logical1: Required. The first condition to evaluate to TRUE or FALSE
- logical2: Optional. Additional conditions, up to 254
Example
=XOR(A1>10, B1>10)
Returns a logical exclusive OR of all arguments
XOR(logical1, [logical2], ...)
=XOR(A1>10, B1>10)