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

HokieLawrence


"Asta" wrote:

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

"Asta" wrote:

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?