Confusing multiple answer function

M

mcowan3

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

Ron Rosenfeld

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.
Click to expand...

=if(c26>33,"high",if(c26>14,"WNL","Low"))


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function 3
Changing cell colors from a function command 3
Excel Logical function 5
Database questions, giving text a numerical value 2
Conditional Formatting Confusion... 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Complicated IF statement - desperately need some help 4
Writing an "IF" Statement 2

Top