Can this be right? Excel has no XOR function???

L

LSB M

Find it hard to believe that Excel doesn't have the exlusive OR
funcion.

I need something to say either A or B but NOT both. I suppose can
write a longer formula to achieve this but.... :confused:
 
D

David Biddulph

davesexcel said:
=IF(A1="No","GoodBye",IF(A1="Yes","Hello",""))

you mean something like this??
Click to expand...

No. The exclusive OR function is
=AND(OR(A1,B1),NOT(AND(A1,B1)))
 
B

Bernard Liengme

No explicit function but you can always make up one
=IF(COUNTIF(A1:B1,"X")=1,TRUE,FALSE)
returns TRUE if and only if there is one X in the range.
 
Top