Help with the IF formula

[Asta]

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?

 

[Peo Sjoblom]

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]

The last reply did help kind of. but its way to confusing for me. I've been
stuck on this problem for about 10 hrs now and i have to hand it in on monday
and i really need to finish the rest which is dependent on that lil bit

 

[HokieLawrence]

=IF(AND(A1>=346,A1<=480),(A1-346)*63.25,IF(AND(A1>=481,A1<=672),(A1-481)*96.40),"no deduction"))

HokieLawrence