Hi I need EXCEL formula help! I just need help on the formula to find taxes owed for Valerie. Since Valerie is False for disable, I think we would just use the first table. Would tax rates just be cells D5:I5? Then income brackets would be C6:I10.

So to find the formula, I think I would use an "IF" and possibly an "AND" in it? But I don't know how to put the stuff inside :/ Please help. Thank you in advance. Also not sure what to categorize this question as so I'm putting it in accounting... If it shouldn't be in accounting please let me know where I should categorize it. Thank you again.

We need to determine the taxes owed by the first employee in the Personnel Data table below by consulting the tax rates in the two tables, collectively named Tax Rates, and the income brackets in a range named IncomeBrackets. A B C H I Annual Income D E F G Taxes Disabled=False Dependents ol1 21 0.00% 0.00% 0.00% 0.00% 15.00% 12.00% 6.00% 5.00% 20.00% 18.00% 9.00% 6.67% 30.00% 28.00% 14.00% 10.00% 38.00% 33.00% 16.50% 12.67% 45.00% 40.00% 20,00% 15.00% $ 50,000.00 $ 90,000.00 $ 140,000.00 $ 180,000.00 $ 225 000.00 0.00% 3.75% 5.00% 7.50% 9.50% 11.25% 0.00% 3.00% 4.00% 6.00% 7.60% 9.00% Annual Income $ - $ 50,000.00 $ 90,000.00 $ 140,000.00 $ 180,000.00 $225,000.00 0.00% 10.00% 15.00% 25.00% 33.00% 40.00% Disabled=True Dependents 3 0.00% 0.00% 0.00% 9.50% 3.50% 2.50% 15.50% 6.50% 4.17% 25.50% 11.50% 7.50% 30.50% 14.00% 10.17% 37.50% 17.50% 12.50% 4 0.00% 1.25% 2.50% 5.00% 7.00% 8.75% 5 0.00% 0.50% 1.50% 3.50% 5.10% 6.50% i. Please indicate the range of cells that each of these named ranges should reference TaxRates Income Brackets Personnel Data 2 Employee Disabled? Dependents Annual Income Taxes Owed 3 Valerie FALSE 0 $ 81,350.00 4 Cheryl FALSE 4 $ 144,350.00 We need to determine the taxes owed by the first employee in the Personnel Data table below by consulting the tax rates in the two tables, collectively named Tax Rates, and the income brackets in a range named IncomeBrackets. A B C H I Annual Income D E F G Taxes Disabled=False Dependents ol1 21 0.00% 0.00% 0.00% 0.00% 15.00% 12.00% 6.00% 5.00% 20.00% 18.00% 9.00% 6.67% 30.00% 28.00% 14.00% 10.00% 38.00% 33.00% 16.50% 12.67% 45.00% 40.00% 20,00% 15.00% $ 50,000.00 $ 90,000.00 $ 140,000.00 $ 180,000.00 $ 225 000.00 0.00% 3.75% 5.00% 7.50% 9.50% 11.25% 0.00% 3.00% 4.00% 6.00% 7.60% 9.00% Annual Income $ - $ 50,000.00 $ 90,000.00 $ 140,000.00 $ 180,000.00 $225,000.00 0.00% 10.00% 15.00% 25.00% 33.00% 40.00% Disabled=True Dependents 3 0.00% 0.00% 0.00% 9.50% 3.50% 2.50% 15.50% 6.50% 4.17% 25.50% 11.50% 7.50% 30.50% 14.00% 10.17% 37.50% 17.50% 12.50% 4 0.00% 1.25% 2.50% 5.00% 7.00% 8.75% 5 0.00% 0.50% 1.50% 3.50% 5.10% 6.50% i. Please indicate the range of cells that each of these named ranges should reference TaxRates Income Brackets Personnel Data 2 Employee Disabled? Dependents Annual Income Taxes Owed 3 Valerie FALSE 0 $ 81,350.00 4 Cheryl FALSE 4 $ 144,350.00