Friday 2 February 2018

microsoft excel - Return a value given that a number is within a certain range

I'm looking for a little help on my scheduled withdrawals problem. I currently solve this with nested IF functions, but I'm getting more and more ranges and that leads to more and more nested IF functions. On top of this I'm running optimization so at a certain point it just explodes.


The problem:


Low        High        Amount to withdraw
600000 2000000 32000
300000 599999 20000
0 299999 8000

So a user would enter in current storage, lets say 325000 and the sheet would spit out 20000. If a user submitted 153555 the answer would spit out 8000


Like I said with just 3 ratchets using nested if clauses isn't impossible, but there can be 10 ratchets and nested if clauses aren't feasible. I'd like to solve this with Excel formulas and not a macro.

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...