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

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:


--
LSB M
------------------------------------------------------------------------
LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258
View this thread: http://www.excelforum.com/showthread...hreadid=564591

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

=IF(A1="No","GoodBye",IF(A1="Yes","Hello",""))

you mean something like this??


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564591

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

"davesexcel" wrote
in message ...

=IF(A1="No","GoodBye",IF(A1="Yes","Hello",""))

you mean something like this??

No. The exclusive OR function is
=AND(OR(A1,B1),NOT(AND(A1,B1)))
--
David Biddulph

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

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.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LSB M" wrote in
message ...

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:


--
LSB M
------------------------------------------------------------------------
LSB M's Profile:
http://www.excelforum.com/member.php...o&userid=36258
View this thread: http://www.excelforum.com/showthread...hreadid=564591