Income Tax Problem
Input a person’s gross salary amount. Program should determine the income tax for that person and print it out. (use the following table)
|
Gross Salary Amount |
Income Tax Percentage |
|
< $8,000 |
0% |
|
$8,000 – $50,000 |
15% |
|
> $50,000 |
30% |
Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdIncomeTax. Place the code under the Click event of a command button titled “Income Tax”.
Hint: Use nested If statements in the flowchart and the code.
