On Thu, 15 Nov 2007 20:16:01 +0000, mcowan3
wrote:


I am trying to figure out how to use an IF statement, but want more than
two answer options.
I want to, based on a range determine if a score is low, within normal
limits, or high. Here is what I am trying to do:
If c26 is less than 15 then "Low"
If c26 is greater than 14 and less than 34 then "WNL"
If c26 is greater than 33 then "high"

Thanks for any help you can provide.

=if(c2633,"high",if(c2614,"WNL","Low"))


--ron