Help with the IF formula

[Guest]

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)

 

[Guest]

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

 

[R.VENKATARAMAN]

the deductions are not clear. as far as I understood I give the vba sub
which you can run. The data is in B7 to B19

Public Sub test()
Dim cell As Range
For Each cell In Range("B7:B19")
cell.Activate
If ActiveCell >= 346 And ActiveCell <= 480 Then ActiveCell.Offset(0, 1) = 63
+ 0.25 * (ActiveCell - 346)
If ActiveCell >= 481 And ActiveCell <= 672 Then ActiveCell.Offset(0, 1) = 96
+ 0.4 * (ActiveCell - 481)
Next
End Sub

see wthether logic of deduction is correct by checking one or two figures
between 346 and 480 and again between 481 and 672 . in C colum you will get
the tax deduction.

is it ok

 

[Guest]

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

HokieLawrence