Get instant live expert help on How do I calculate average tax rate

I need to use a Nested IF formula using structured references and range names to calculate the tax based on the following rules: If a customer doesnt pay tax, the tax rate is 0, if the customer pays tax, the tax rate is based on the type of customer. Tax rates are found on the Tax Rates worksheet. I need to give each tax rate on the tax rates sheet a range name: COM, GOV & NPROFIT. I need to use that range name in the formula.

Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E25. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay.

if an employee has a taxable income of greater than $739, then the federal tax withheld equals $110.85 plus the federal tax rate found in cell B19 multiplied by the taxable income in excess of $739. If employees taxable income is $739 or less, the federal tax withheld equals the taxable income multipled by the federal tax rate found in cell B18. Use the IF function to calculate the federal tax.

I want to input a tax rate into a table and then have the tax rate show up in descending columns in the spread sheet.

Calculate the federal tax withheld. If an employee has a taxable income of greater than or equal to $689, then the federal tax withheld equals $110.85 plus the federal tax rate found in cell B16 multiplied by the taxable income in excess of 689