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

Returns the logical exclusive OR for any number of arguments.

logical1The first logical value.
logical2(Optional) The second logical value.

Remarks

* Added in Excel 2013.
* This function returns either True or False.
* This function returns True when the number of True parameters is odd.
* This function returns False when the number of True parameters is even.
* The logical values can be constants, logical equations, cell references or named ranges.
* You can use this function to see if a value occurs in an array.
* You can have a maximum of 254 arguments (not 255).
* All the arguments must evaluate to logical values (either true or false).
* You can use the AND function to return the logical AND for any number of arguments.
* You can use the NOT function to return the opposite of a True or False value.
* You can use the OR function to return the logical OR for any number of arguments.
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top