View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jayseeca
 
Posts: n/a
Default Is there such a formula? ... Yes/No?

Wow, thanks very much! I thought I had hours of tedious calculation ahead of
me.
Thanks again.

"Peo Sjoblom" wrote:

Yes

http://www.mcgimpsey.com/excel/variablerate.html

Regards,

Peo Sjoblom

"jayseeca" wrote:

The best way to explain my question is by an example:
Lets say I have a bunch of numbers, one of them being 100,000.
Is it possible to create a formula in an Excel cell, which will tell me a
value when I want to sum -
the first 5,000 of the 100,000 multiplied by 14%, then add the NEXT 5,000 *
10%, added with the NEXT 10,000 * 8%, and more than 20,000 of the 100,000
multiplied by 5%.
Then carry on this formula to other values, such as 150,000; 254,948... etc

Does anyone understand what I'm asking?