XOR(logical1 [,logical2] [..]) |
Returns the logical exclusive OR for any number of arguments. |
| logical1 | The 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 |
|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top