Multiple Numeric to Text

[jamesjra]

Hi,

I need to take a numeric value of a cell, (1,2,3), and then in a
seperate cell display the text 'Yes','no', 'N/A' respectively.

Any help would be much appreciated, seem to have hit a wall

J Calvert

 

[Paul]

Hi,

I need to take a numeric value of a cell, (1,2,3), and then in a
seperate cell display the text 'Yes','no', 'N/A' respectively.

Any help would be much appreciated, seem to have hit a wall

J Calvert

=IF(A1=1,"Yes",IF(A1=2,"no","N/A"))
Replace A1 with the cell you want to test.

 

[jamesjra]

Thanks

 

[Gord Dibben]

=CHOOSE(A1,"good","ok","bad","very bad")

Will choose from 1,2,3 or 4 in A1

Adjust to suit.

Gord Dibben Excel MVP