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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!