One way would be to set up a criteria page with all your numbers
listed and becide those numbers place their outcomes. Then complete a
Vlookup based on the criteria.

This will only work if the figures you are looking at are whole
numbers.

Oz.

On Feb 21, 12:42 pm, tam25 wrote:
I am trying to get a formula that will do the following:

a score of:
0-9 = normal
10-13 = mild
14-20 = moderate
21-27 = severe
28+ = extremely severe

i tried doing an if function but it won't allow more than 5 (i think) if
functions. could someone please advise if 'if' is the function to use or
whether I should be trying something else?

thanks heaps