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
Bookmarks