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.
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.