(1-10000) at 30% = 30000

Hi. Just to mention...

=10000*30% = 3000

I was thinking the solution might be 5808.

Here's my guess...

=MIN(3000 + 0.18*A1,1800 + 0.21*A1, 900 + 0.24*A1,300 + 0.27*A1, 0.3*A1)

--
HTH
Dana DeLouis
Windows XP & Excel 2007


"Rykar2" wrote in message
...
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.