Using VLOOKUP formulas to the 2022 tax brackets.

HINT: Use the TRUE logical value.

Someone please help! I have so much trouble with the codes so If you could use the codes needed would be great! Thank you!

It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse have been amicable, and Marie is looking forward to being single. The divorce attorneys will be ready to complete the proceedings before December 31 , but Marie is concerned about tax implications. Marie has asked for your help in determining whether to wait until the beginning of next year in order to minimize taxes. The couple has two children and expect each will take custody of one child maintaining their own households. Marie's taxable income is $90,000 while he soon-to-be ex-spouse's taxable income is $40,000. Ignore any tax credits in your analysis. 17 A B C. D Schedule X-Single B C Option 1 Filing Status: Taxable Income: If taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: Grand Total Tax: 5 to show your work. 2022 Tax Rate Schedules Individuals It's mid-December and Marie is finalizing her divorce. Generally, she and her soon to be ex-spouse have been amicable, and Marie is looking forward to being single. The divorce attorneys will be ready to complete the proceedings before December 31 , but Marie is concerned about tax implications. Marie has asked for your help in determining whether to wait until the beginning of next year in order to minimize taxes. The couple has two children and expect each will take custody of one child maintaining their own households. Marie's taxable income is $90,000 while he soon-to-be ex-spouse's taxable income is $40,000. Ignore any tax credits in your analysis. 17 A B C. D Schedule X-Single B C Option 1 Filing Status: Taxable Income: If taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: Grand Total Tax: 5 to show your work. 2022 Tax Rate Schedules Individuals