Ah, I thought you meant that you had only one percentage which applied
to the value. As your percentages are compounded, the link to JE's
site that Ragdyer gave you earlier, i.e.:

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

explains very well how to accomplish this, either using a single
formula or with tables.

Hope this helps.

Pete

On May 16, 3:33 am, Rykar2 wrote:
Thanks for you answers but I will explain different:
I was entering the result manually and this is the end result:
I have the amount of 20450 in A1.

(1-10000) at 30% = 30000
(10001-20000) at 27% = 27000
(20001-30000) at 24% = 108
(30001-40000) at 21%
(Over 40001) at 18%
Total = 57108

Ron and Pete if you try this with that formula you will notice the result is
0.24. In this case I need the first 10K calculated at 30%, the second 10K
calculated at 27% and so on, and at the end I am adding that column to get
the total. Now, you can see that the line for 21% and 18% do not apply so I
need the result to be 0.