MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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....

Posted by on January 20, 2002 2:54 PM

=If(Right(Employee#,1)=1,A1,K3*L3)*0.062 (NT)