multiple if functions
I'd use the VLOOKUP function.
If you have the numbers in column A and you want the words in column B
consider this:
Put this in column B:
=VLOOKUP(A1,C$1:D$5,2)
and this table in column C1 and D1:
0 normal
10 mild
14 moderate
21 severe
28 extremely severe
|