LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup confusing jag53 Excel Worksheet Functions 4 June 28th 07 04:26 PM
multiple lists that return an answer v&sr4JC Excel Worksheet Functions 1 March 24th 07 05:14 AM
Confusing Problem Cincy Excel Discussion (Misc queries) 2 July 13th 06 09:19 PM
Rebate incentive - Multiple tier payback - Confusing if Statement IntricateFool Excel Discussion (Misc queries) 2 March 28th 06 11:13 PM
Get Vlookup to look at multiple Rows for the answer KDuxbury Excel Worksheet Functions 1 October 12th 05 03:21 PM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"