I need a formula that will automatically calculate the Federal withholding on an employee's check based on gross wages. Here's my info: Wage Bracket Percentage Method Table for Computing Income Tax Withholding From Gross Wages Employer's Tax Guide Pub. 15A. This Table shows for i.e. if an employee has less than 40 hours and he will make over $0 but not over $472.30, then subtract $241.30 from gross wages, multiply the results by 10%. This is what you would withhold on Federal. But that employee has 40 hrs the next week here is what you're working with: Gross wages are $472.30 but not over $1,124.30 subtract 318.30 from gross wages and multiply results by 15%. What formula can I put in that will calculate federal withholdings based on gross wages no matter how many hours the employee has. Here is what I tried but didn't work =IF((gross wages>=472.30),0,(gross wages-318.30)*15%,(gross wages-241.30)*10%)Please Help
This message was edited by laclewis on 2003-01-14 17:44
This message was edited by laclewis on 2003-01-14 17:44