If function

[Stuart Hagon]

Hi All

Can anyone help me; I have a column in my spreadsheet
which has numbers from 0 to 3 which relate to the status
of a customer. 0 being open 3 being closed. i the next
column I need to translate these numbers in to the
appropriate words. Can anyone tell me how this can be
done?

Thanks

 

[Frank Kabel]

Hi
if you have only 4 status values try
=IF(A1=0,"stat1",IF(A1=1,"stat2",IF(A1=2,"stat3",IF(A1=3,"stat4",""))))

If you have more values yoh may consider creating a lookup table and
using vLOOKUP

 

[Guest]

Thanks For that Frank, just what i needed

-----Original Message-----
Hi
if you have only 4 status values try
=IF(A1=0,"stat1",IF(A1=1,"stat2",IF(A1=2,"stat3",IF (A1=3,"stat4",""))))

If you have more values yoh may consider creating a lookup table and
using vLOOKUP


--
Regards
Frank Kabel
Frankfurt, Germany




.