need formula to calculate SSn tx automatic every payperiod without calculating every pay period, until client reaches max deduction and SSn equal zero. =RoundIf,(I13>$G$25,0,If(I13+C13)>$G$25,IF($I$13-$g$25)*G23,(C13*G23)),2),) Accum Income 80,000 & current income 5,000 is greater than Max Fica tax 89,000, If current Accum if greater than max, result is zero, but if Accum is less I want excel to munus kAccvum from the Max Fica Tax, multiply differents times rate of 6.20 for result. and change every pay period automaticly, untill client reaches max, and has zero comming of check...

Imo

what doest the work deduction have to do with, my question, I need help with the formula

I posted, I need help on What I'm doing wrong on the formula, I have error on the section(I13+C13), no other part help...explain.....

Since you are probably taking about an office spreadsheet, you should have posted under office software to get the attention on those who have more experience in this area. (maybe they can move it for you) You have to be a little bit crazy to keep you from going insane.

This site is about helping people, lets keep it that way.

Ask Your Question

Weekly Poll