Check out this link to J.E. McGimpsey's web page on this very subject:
http://www.mcgimpsey.com/excel/variablerate.html
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rykar2" wrote in message
...
Hi,
Could you please help me with a formula for the following situation:
I have the amount of 20450.
(1-10000) at 30%
(10001-20000) at 27%
(20001-30000) at 24%
(30001-40000) at 21%
(Over 40001) at 18%
But if the result is less than 0 then I need the cell to show 0.
Is there a formula for this?
Thanks in advance.