XOR function.Conditional judgment of exclusive OR.(Microsoft Excel)


Japanese version.

A companion to the AND and OR functions, it retrieves the exclusive OR.

XOR is TRUE only if all of the logical expressions in the argument are TRUE or all are FALSE, otherwise it is FALSE.

How it works

XOR(logical1 to 254)
logical1 to 254logical1 is required.Up to 254 conditional expressions or logical values that are TRUE or FALSE can be specified.
At least one is required, but two should be specified for practical use.

Example Results

This is an example of executing the XOR function and comparing it with the AND and OR functions.


To "Spill" the function, use the BYROW and BYCOL functions.




Logical(Microsoft Excel Functions)