Originally Posted by David Biddulph[_2_]

Ron has given you an answer, but rather than "Confusing multiple answer" you
might have entitled your thread "Confusing question". You have defined a
condition for C26<15, but then your next condition starts with C2614, so
it's unclear what you want for values between 14 and 15. You have a similar
ambiguity between 33 and 34. You may wish to reconsider your requirements?
--
David Biddulph

"mcowan3" wrote in message
...

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