Put this formula in B1..........

=IF(A1=1,"R",IF(A1=2,"S",IF(A12,"Yes","")))

Vaya con Dios,
Chuck, CABG3



"Portuga" wrote:


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