Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
what is the formula required to stop employee and employer paid taxes once a
tax limit criteria has been met? Ex. once 7000.00 in gross wages has been met, you no longer have to take out FUTA. It is easy to figure out the formula above and well below 7000.00, the problem is that one pay period when they finally meet the 7000.00, but it does not know what to do with the excess amount. Example. pay period 1 - employee gross wages are 2000. Tax formula works fine. Pay perios 2, another 2000 in wages, now YTD total is 4000. Still fine. Pay period 3, another 2000, everything still fine because YTD is now 6000. But now on pay period 4 - another 2000, but now it jumps to 8000 YTD. But my forumula does not work, because he went over 7000, but it didn't know how to add just the 1000 difference to cap the FUTA at 7000. anyone out there that knows what the formula would be, please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula in a cell to calc FUTA tax | Excel Worksheet Functions | |||
Payroll tax deductions | Excel Discussion (Misc queries) | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
need spreadsheet for the calculation of FUTA & SUTA payroll taxes | Excel Discussion (Misc queries) | |||
How do I setup a formula for payroll deductions in excel | Excel Worksheet Functions |