LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Function giving a result for number within a range

Hi,

I'm very new to using functions within Excel and I'd like some help
from anyone willing to bear with me. I would like to set up a
spreadsheet where I can enter a number, and based on where that number
falls within set ranges, I would end up with a preset result. For
example:

An entry of "0.85" would fall into the range of "0 - 0.99." That range
would have "0.20" as a result for any number falling within it. There
would be multiple sets of ranges, about 10.

I hope I am explaining this ok. Let me know if you can help!

-Nick

 
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
Currency to Text mytipi Excel Worksheet Functions 1 February 21st 06 11:43 PM
spell number JAWAD CHOHAN Excel Worksheet Functions 1 December 12th 05 05:58 PM
Convert number into words Blackwar Excel Discussion (Misc queries) 4 December 2nd 05 12:05 PM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM


All times are GMT +1. The time now is 02:49 PM.

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"