Microsoft Office Tutorials and References

In Depth Information

**Syntax**

The arguments logical1,logical2,... are one to 255 conditions that can evalu-

ate to TRUE or FALSE.

Syntax

XOR(logical1,logical2,...)

The XOR function checks whether an odd number of the arguments are TRUE.

The arguments logical1,logical2,... are one to 254 conditions you want to test

that can either be TRUE or FALSE. They can be logical values, arrays, or

references.

In
Figure 12.4
,
the OR function in column E is contrasted with the XOR function

in column F.

Figure 12.4.

Figure 12.4.
OOR checks whether a record meets at least one of several cri-

checks whether a record meets at least one of several cri-

teria.

teria. XOR

XOR checks to see if an odd number of criteria is true.

checks to see if an odd number of criteria is true.