=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