[AccessD] More Of An Excel Question Really

[Susan Harkins]

Does it really have to be one formula? This would be much simpler with four formulas, that simply subtract. 

Susan H. 


Answer:

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

 

ANSWER NUMBERS

  50+

150+
280 =
--------

480

 

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

 

Darren

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com