Hi

In Cell A1 I have Possible Values from 1 to 6.
I want to have the following conditions in B1:

If a1=1 then "R",
If a1=2 then "S",
If a12 then "Yes"

Thanks!


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=506815