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.
Search JabSto ::




Custom Search