asking excel to return a label for a value range

[gbaynam]

Sorry for a noob question, but i don't know how to get excel to return a label for a value if it is within a certain range. Tried F1 and searching boards but there are heaps of topics... I suck with computers.

Basically i want it to say that if a value in cell 1A is between 0 and 9 then to give it the label (in cell B1) of "NORMAL". 10-19 as "MILD", 20-29 as "MODERATE" and 30+ as "SEVERE"

I posted here once before and you guys were great help. Hope you can help again.

 

[patrickmuldoon99]

Hi GBaynam

Try;

=IF(A1<=9,"NORMAL",IF(A1<=19,"MILD",IF(A1<=29,"MODERATE","SEVERE")))

Enter the formula in B1 and drag down to suit

HTH