Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel Programming » Excel Worksheet Functions » problem with number ranges

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-01-2009, 01:26 PM
mehdoush mehdoush is offline
Registered User
  
Join Date: 20 Feb 2009
Location: La, CA
MS Office Version:Excel 2003
Posts: 70
mehdoush is becoming part of the community
problem with number ranges

Please Register to Remove these Ads

hey guys,

i'm using a table like this:

1 to 10% |11 to 20%| 21 to 30%
good | well | very well

if for examp. i put in a textbox a percentage between 1 and 10 it must write "good" and so ...


thanks in advance for help
regards
Reply With Quote
  #2  
Old 07-01-2009, 07:36 PM
kellyfspringer kellyfspringer is offline
Registered User
  
Join Date: 06 May 2009
Location: Pennsylvania, USA
MS Office Version:Excel 2007
Posts: 82
kellyfspringer has been very helpful
Re: problem with number ranges
Make a reference list Column A/Column B:
1/Good
11/Well
21/Very well

Say you are putting your value in cell F2, put this formula in G2:
=LOOKUP(F1,A1:B3)

If you plug in "5" into F2, the formula will result with "Good", "15" with "Well" and so forth.
Reply With Quote
  #3  
Old 07-01-2009, 07:43 PM
Chance2 Chance2 is offline
Forum Contributor
  
Join Date: 01 Apr 2009
Location: Irvine, CA
MS Office Version:Excel 2003
Posts: 160
Chance2 has an addiction to Excel
Re: problem with number ranges
You could just use the LOOKUP formula with your variables/results as part of the formula:

Code:
=LOOKUP(A1,{1,11,21},{"Good","Well","Very Well"})
Where the LOOKUP VECTOR is the low end of the range you are looking for.
Reply With Quote
  #4  
Old 07-01-2009, 11:19 PM
kellyfspringer kellyfspringer is offline
Registered User
  
Join Date: 06 May 2009
Location: Pennsylvania, USA
MS Office Version:Excel 2007
Posts: 82
kellyfspringer has been very helpful
Re: problem with number ranges
Chance2, that is great!
Reply With Quote
  #5  
Old 07-02-2009, 01:53 PM
mehdoush mehdoush is offline
Registered User
  
Join Date: 20 Feb 2009
Location: La, CA
MS Office Version:Excel 2003
Posts: 70
mehdoush is becoming part of the community
Re: problem with number ranges
thank you guys

respect ...
Reply With Quote


Reply

Bookmarks

Tags
cell , textbox

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top