"Answer in MS-Excel Developer"

Write a Function subroutine called Tax that takes a single argument grossIncome of type Currency. It should calculate the tax on any income using the following tax schedule: (1) if income is less than or equal to $15,000, there is no tax; (2) if income is greater than $15,000 and less than or equal to $75,000, the tax is 15% of all income greater than $15,000; and (3) if income is greater than $75,000, the tax is 15% of all income between $15,000 and $75,000 plus 20% of all income greater than $75,000. Then write a "CalcTax" sub to run the function in the worksheet itself for the following Income amounts:

10,000

50,000

100,000

These three values should be found in your first column, and the second column will use the function to compute the tax amount.

"The correct outputs should display as below":

$0

$5,250 ((50,000 - 15,000) * 0.15)

$17,000 ((75,000 - 15,000) * 0.15) + ((100,000 - 75,000) * 0.20)