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)