top of page

XOR function

Count cells between dates.png

Description

This XOR function perform what is called "exclusive OR". The two logical statements or XOR return TRUE if either one statement is TRUE. It will return FALSE is both statement are TRUE. If neither is TRUE, it will return FALSE as well.

Objective

Perform exclusive OR.

Syntax

=XOR(logical1,[logical2],....)

Arguements

logical1 - expression, constant or reference that return TRUE or FALSE.

logical2 - [optional] expression, constant or reference that return TRUE or FALSE.

bottom of page