See this:

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


--
Biff
Microsoft Excel MVP


"SueG123" wrote in message
...
I need a formula for calculating the tax on a profit amount based on the
following scales so I can quickly calculate tax payable to accrue in my
accounts
0-25k 5.3%
25-200k 15.3%
200-400K 22.4%
400-1M 28.8%
1M-5M 33.8%
eg if profit was 200k then 1st 25K @5.3 and then 175K @15.3%
Would appreciate anyone who is able to give me some help on this