asking excel to return a label for a value range

gbaynam

New Member
Joined
Oct 26, 2006
Messages
3
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.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
Hi GBaynam

Try;

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

Enter the formula in B1 and drag down to suit

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,330
Members
409,863
Latest member
stacy09
Top