|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.|
I128 = Hire date
O128 = pay per workday
T122 = work days per month
R128:S128 = Jan and Feb FICA wages
The 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.