Posted by Stressed on January 20, 2002 2:34 PM
Here is the problem.
I have this in my spreadsheet
231958471 (A1) 32500.00 (K3, Pay) 160 (L3, Hours Worked)
I need a formula to pull out the 1(salary) in A1 and calculate FICA taxes. All employees pay FICA in the amount of 6.2% unless they earn over 68,400.00. I also have to set it up to determine if the last number is a 1 or a 2 because if it is a 2(hourly) then I have to calculate it to multiply the hours worked (L3) by the rate of pay (K3)then multiply the 6.2%...
Any suggestions??? All is appreciated....