USING SIMPLE and NESTED-IF FUNCTIONS Calculate taxes paid by Carlos, Jane, and Chang and fill out the taxes paid" number on cells on B22 to D26 (Under each Scenario). Taxes paid are calculated for each scenario using following logic: Scenario 1 If net income is greater than $15,000, taxes paid = $1000, else taxes paid = $400, Scenario 2 If net income is greater than $15,000, taxes paid are 28% of net income above $15,000, else taxes paid are 15% of net income above $8,000. Scenario 3 If net income is greater than $15,000 and less than $35,000, taxes paid are 28% of net income above $15,000, else taxes paid are 15% of net income. Scenario 4 If net income is at least $15,000 and at most $35,000, taxes paid are 28% of net income above $15,000, else, If net income is less than $15,000 then taxes paid are 15% of net income above $8,000. else, If net income is greater than $35,000, taxes paid are 33% of net income above $35,000, Scenario 5 If net income for a person is greater than 15% of their Salary, then remark should say "Need More Tax Breaks!" Else, it should say "Good Job on Taxes!" CARLOS JANE CHANG SALARY $54,000.00 $75,000.00 $60,000.00 DEDUCTIBLE EXPENSES $40,000.00 $51,000.00 $52,000.00 NET INCOME $14,000.00 $24,000.00 $8,000.00 TAXES PAID Carlos Chang Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Jane