the following is what I need but cannot get close to what I need to do. Any help is appreciated...



In cell a2 IF A1 >0 BUT < 96 THEN A3
OR IF A1 > 96.01 but< 192 THEN A4
OR IF A1>192 but < 288THEN A5
OR IF A1>288 but < 384 THEN A6
OR IF A1>384 but <769 THEN A7
basically it is a tax withholding formula for my business.
to appear in a2


Thank In Advance

Maybe:

=IF((A1>384)*(A1<769),A7,IF(A1>288,A6,IF(A1>192,A5 ,IF(A1>96,A4,IF(A1>0,A3)))))

If this is not what you want, please give a detailed example.

MORE THAN NOT MORE THAN WITHOLD OVER
$0.00 $96.15 $0.00 PLUS 0.556%
$96.16 $192.30 $0.53 PLUS 1.112% $96.15
$192.31 $288.45 $1.60 PLUS 2.226% $192.30
$288.46 $384.60 $3.74 PLUS 2.782% $288.45
$384.61 $769.20 $6.41 PLUS 3.338% $384.60
$769.20 $1,538.40 $19.25 PLUS 3.894% $769.20

$256 <<<that is the pay so I would deduct $192.30 from the 256 and take 2.782%and $1.60 from that remainder for a total tax of $3.02


=IF((A1>384)*(A1<769),A2,IF(A1>288,A3,IF(A1>192,A4 ,IF(A1>96,A5,IF(A1>0,A6)))))

this FORMULA (THE ONE FROM XOR) sort of works, but not quite. I need it to reference cells, that I will put in the actual formulas, n=but if you can make the above table work that would be great.

Is it like shown in the attached?

Attached Files

Tax.xlsx (14.8 KB, 10 views)

That works very well. The only problem with (me) and vlookup is, I have many employees and I do payroll in a different worksheet inside one work book. and I am using a vlookup for the tax table now and had it set for 2 years but now have to extend it for another 2 years and I Cannot figure out how to copy the previous good vlookup cell to the new and have it change the cell I need to change and have the vlookup box stay the same. So I copy down 104 weeks and then have to go to each week and change the vlookup so it is right and have to do this with 13 employees and one employee took me 2.5 hours last nigh. that's Why I was hoping to do a multiple if statement. I can do 1 if statement but need 5 in the same line and don't know what separator to use. Sorry for the length but its the best way I can fully explain.

Is it better now?

Attached Files

Tax_2.xlsx (15.0 KB, 11 views)

Perfect. Thank you for saving me hours