View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Craig Josh Craig is offline
external usenet poster
 
Posts: 40
Default 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