Question: What would be the Excel IF Statement that would be inputted to find the Tax Rate for each level of Employee Income? For this example,
What would be the Excel IF Statement that would be inputted to find the Tax Rate for each level of Employee Income?
For this example, if employee income is: If income is less than $29,701, then the tax rate is 15%; else if income is greater than or equal to $29,701, but less than $71,950, then the tax rate is 25%; else if greater than or equal to $71,950, then the tax is 28% Employee Income Tax Rate $ 35,000.00 $ 21,000.00 $ 80,000.00 $ 100,000.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
