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