# FICA Wages Monthly Calculation

September 16, 2015 at 12:35:35
Specs: Windows 7
 I am attempting to use an IF statement to determine the monthly FICA wages per employee. The ceiling is \$118,500. I also want to consider the hire date in the formula. The following formula is not providing accurate results.=IF((IF(\$I128<="3/31/16",\$O128,0)*T\$122+SUM(\$R128:S128))<=118500,IF(\$I128<="3/31/16",\$O128,0)*T\$122,0)I128 = Hire dateO128 = pay per workdayT122 = work days per monthR128:S128 = Jan and Feb FICA wagesThe goal is the use the formula to waterfall out the FICA wages over the months taking into account employees starting during the year as well.

See More: FICA Wages Monthly Calculation

#1
September 16, 2015 at 14:38:25
 What result are you getting? Are you trying to calculate the wages, or the 6.2 percent tax and for what length of time?I could be totally clueless (it's been known to happen,) but I'm not understanding exactly what is it you're trying to determine.Perhaps you could provide examples of entries in the cells listed in your formula.message edited by Jennifer SUMN

Report •
Related Solutions