T
Tia
I'm trying to set up a macro on my payroll sheet that will calculate if FICA
is due. Basically, I have a list of employees and I need to be able to
account for those employees that cap out of FICA. Right now, I've got a YTD
column (C), Employees (Rows 1-15), FICA (D). The amount entered in Column D
(FICA) depends on how much the employee has earned YTD. For example, FICA
will be paid by all employees who have made less than 97000 (Column C). Once
an employee reaches 97000, then they no longer pay FICA. We used to use
Lotus and I'm not familiar with how a macro works in Excel. Where would I
start to create a macro????
is due. Basically, I have a list of employees and I need to be able to
account for those employees that cap out of FICA. Right now, I've got a YTD
column (C), Employees (Rows 1-15), FICA (D). The amount entered in Column D
(FICA) depends on how much the employee has earned YTD. For example, FICA
will be paid by all employees who have made less than 97000 (Column C). Once
an employee reaches 97000, then they no longer pay FICA. We used to use
Lotus and I'm not familiar with how a macro works in Excel. Where would I
start to create a macro????