How to assign text to a range of values

**shalani** · 08-25-2011, 04:06 AM

Hi there, I'm new here. Is there a way to get Excel to insert a text or time to correspond to a value?

For example, through calculations,

=A1+B1, I get 2 (in C1) and so I need D1 to state 'Good'

And if =A2+B2 equals 3 (in C2) then I need D2 to be 'Average'
=A3+B3 equals 4 (in C3) then D2 will be Bad.

Just a simple example but that is basically what I need done. And it is to be associated with those exact words Good, average and bad.

Thanks!

**Azam Ali** · 08-25-2011, 04:10 AM

in D1 use

=IF(C1=2,"Good",IF(C1=3,"Average",IF(C1=4,"Bad"))) and copy down
or
=IF(C1=2,"Good",IF(C1=3,"Average","Bad"))

or
in D1 =IF(C1=2,"Good","")
in D2 =IF(C2=3,"Average","")
in D3 =IF(C3=4,"Bad","")

**Azam Ali** · 08-25-2011, 04:22 AM

also in D1
=CHOOSE(C1,"","Good","Average","Bad") and copy down

if you define this range i.e. 2=Good, 3=Averager, 4=Bad and so on in a seperate table. then you could also use vlookup function

**shalani** · 08-25-2011, 04:33 AM

[QUOTE=Azam Ali;2586700]in D1 use

=IF(C1=2,"Good",IF(C1=3,"Average",IF(C1=4,"Bad"))) and copy down
or
=IF(C1=2,"Good",IF(C1=3,"Average","Bad"))

Hey Azam, thanks it worked like a charm!

Sorry to bother you again but does the above formula work for ranges too? eg. 20-24 and then 25-29 to get good, average and bad.

Once again thanks, have been working at this for a long time.