[AccessD] More Of An Excel Question Really
ssharkins at gmail.com
Tue May 12 09:16:02 CDT 2020
Does it really have to be one formula? This would be much simpler with four formulas, that simply subtract.
50K of that 480 fits into tier 1 (430k remaining)
150 of that remaining 430k fits into tier 2 (280k remaining)
280 of that 280k fits into tier 3 (all monies exhausted)
No further tier assignment required
How would the Answer above be built as a formula in excel though?
i.e. I type in an expected gross amount into a cell (In this case 480,000)
The formula instantly assigns those 3 x ANSWER NUMBERS above to the relevant tiers?
Hope it makes sense
Many thanks in advance
AccessD mailing list
AccessD at databaseadvisors.com
More information about the AccessD