Question: Hello Just need help on Question 4. Thank you. 4- In cells C24:E24, develop your IFS Function or (Nested IF Functions, depending on your answer
Hello Just need help on Question 4. Thank you.
4- In cells C24:E24, develop your IFS Function or (Nested IF Functions, depending on your answer to Q3) to have Excel automatically calculate the tax liabilities of the three individuals' taxable income.

TAX TABLE: 2020 Federal for Unmaried Individuals Questions \begin{tabular}{cccr} \hline \multicolumn{2}{l}{ Calculating tax on base } & & \\ \hline \hline \multicolumn{2}{c}{ Income Brackets } & Tax Rate & Tax on Base \\ \hline \hline$0 & $9,875 & 10% & $0 \\ \hline \hline$9,876 & $40,125 & 12% & $988 \\ \hline \hline$40,126 & $85,525 & 22% & $4,617 \\ \hline \hline$85,526 & $163,300 & 24% & $14,605 \\ \hline \hline$163,301 & $207,350 & 32% & $33,271 \\ \hline \hline$207,351 & $518,400 & 35% & $47,367 \\ \hline \hline$18,401 & & 37% & $156,234 \\ \hline \hline \end{tabular} 1-Calculate the tax on base in E6:E12 2- Using simple Excel formulas, calculate in cells C21:E21 the tax liability for each of the three individuals' taxable income. 3- Develop a pseudo code to help you develop your IFS Function to calculate the tax liability of the same three individuals taxable income. (If you prefer, you can use Nested IF Functions) '4- In cells C24:E24, develop your IFS Function or (Nested IF Functions, depending on your answer to Q3) to have Excel automatically calculate the tax liabilities of the three individuals' taxable income. 5- Copy your worksheet and in the new one, update the tax table to display 2021 Federal for Unmarried Individuals (info in slides). Did the tax liability of any of the three individuals change? Calculating tax liability using IFS function Tax Amount: Developing a pseudo code \begin{tabular}{c|c} \hline Logical Test 1 & Income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
