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

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Asta" wrote in message
...
i have created a payroll spreadsheet and now im currently having issues
with
adding the tax.
The tax goes like this:
if $346 - $480 deduct $63 and 25c for each dollar over $346
$481 - $672 deduct 96 and 40c for each dollar over $481

i just need help in how i'd go about making a formula like that. there is
alot more like that but i'd be able to figure it out i just need to know
how
i would go creating such a formula?