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.

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

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

David, The numbers on this spreadsheet are all whole numbers, but I guess if I were to include everything between I would use <= 15, =14 and the same for 33 and 34.

Thanks for pointing out the flaw in my logic, i will adapt the answer to make sure I cover all of the bases.
Marshall