Description: XOR-Function with a odd number of "TRUE" parameter is "TRUE", should be "FALSE" except of one "TRUE" parameter example: XOR(1,1,1) = TRUE should be FALSE Steps to Reproduce: 1.use the XOR function with an odd number of "TRUE" parameter 2. 3. Actual Results: incorrect behavior of xor function Expected Results: xor is TRUE only when one parameter is TRUE, otherwise it is FALSE Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
(In reply to ludwig.bedau from comment #0) > Actual Results: > incorrect behavior of xor function > > Expected Results: > xor is TRUE only when one parameter is TRUE, otherwise it is FALSE it works as documented https://help.libreoffice.org/Calc/Logical_Functions#XOR
If you have one argument set to true(), it returns true. With a second one it returns false. With a third one it returns true again and so on. But, if I check out the example from here: https://support.office.com/en-us/article/XOR-function-1548d4c2-5e47-4f77-9a92-0533bba14f37 =XOR(3>0,2<9) This one should return true, but returns false with calc. So who's right here ?!
(In reply to MM from comment #2) > But, if I check out the example from here: > https://support.office.com/en-us/article/XOR-function-1548d4c2-5e47-4f77- > 9a92-0533bba14f37 > =XOR(3>0,2<9) This one should return true, but returns false with calc. So > who's right here ?! congratulations you found a bug in the Excel online help. please report it to their bugzilla or whatever... Excel 2016 got it correct result: FALSE
Let's close, then.