(Solved) : Cell G12 Write Formula Calculate Total Tax Amount Alternate 1 Income Cell B12 Use Hlookup Q27859884 . . . .

In cell G12, write a formula to calculate the total taxamount for Alternate 1 on the income in cell B12. Use the HLOOKUPfunction to determine the Alternate 1 flat tax rate for the incomein cell B12 and then multiply by the income to get the dollaramount owed. If done properly the result in G12 should be14,462.

Make sure you have used absolute referencesappropriately and then autofill down.

In cell H12, write a formula to calculate the total taxamount for alternate 2 on the income in cell B12. Use the HLOOKUPfunction to determine the Alternate 2 flat tax rate for the incomein cell