View Single Post
  #1   Report Post  
mcowan3 mcowan3 is offline
Junior Member
 
Location: Washington DC
Posts: 5
Default Confusing multiple answer function

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.