software

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 quot;0.85quot; would fall into the range of quot;0 - 0.99.quot; That range
would have quot;0.20quot; 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!

-NickHi Nick.....
There is a standard feature in Excel that will do exactly as you wish. It's
called VLOOKUP. First thing you would do is make a list down a column
starting with zero in say L1 and if you're using .01 increments, then use
1.00 in L2, and say go up from there to .01 ABOVE your cutoff point in each
case.....and then put the value you wish to retrieve in column M adjacent to
each value, but at the LOWER end of each range.
say L1 = 0
L2 = 1
M1= .20
M2=whatever, for the next increment........

Then assuming your quot;entryquot; number would be in A1, put this formula in B1 or
wherever you wish...

=VLOOKUP(A1,L:M,2,TRUE)

If you have trouble, post back and someone will help.....

Vaya con Dios,
Chuck, CABGx3
gt; wrote in message oups.com...
gt; Hi,
gt;
gt; I'm very new to using functions within Excel and I'd like some help
gt; from anyone willing to bear with me. I would like to set up a
gt; spreadsheet where I can enter a number, and based on where that number
gt; falls within set ranges, I would end up with a preset result. For
gt; example:
gt;
gt; An entry of quot;0.85quot; would fall into the range of quot;0 - 0.99.quot; That range
gt; would have quot;0.20quot; as a result for any number falling within it. There
gt; would be multiple sets of ranges, about 10.
gt;
gt; I hope I am explaining this ok. Let me know if you can help!
gt;
gt; -Nick
gt;
Worked just as I wanted it to. Thanks!Youre quite wecome......glad to be of help.......thanks for the
feedback.....

Vaya con Dios,
Chuck, CABGx3gt; wrote in message oups.com...
gt; Worked just as I wanted it to. Thanks!
gt;