Multiple Numeric to Text

  • Thread starter Thread starter jamesjra
  • Start date Start date
J

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
 
jamesjra said:
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
Click to expand...

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

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

Adjust to suit.

Gord Dibben Excel MVP
 
Back
Top