1. Create the IFS formula in Cell C2 to calculate the tax due based on the employee's income. * 2 points Your answer 2. Create the IFS formula in Cell C3 to calculate the tax due based on the employee's income. Your answer * 2 points 3. Create the IFS formula in Cell C4 to calculate the tax due based on the employee's income. * 2 points Your answer4. Create the IFS formula in Cell C5 to calculate the tax due based on the employee's income. * 2 points Your answer 5. Create the IFS formula in Cell C6 to calculate the tax due based on the employee's income. * 2 points Your answer

Problem: Tax Bracket An HR officer is tasked to compute the monthly tax deduction of employees. The monthly income of each employee is recorded in Column B. The tax is computed based on the following brackets: -If the income is 400,000 or more, the tax is 30% of income. -If the income is between 250,000 and 399,999 the tax is 25% of income. -If the income is between P'100,000 and 249,999 the tax is 20% of income. -If the income is between 50,000 and 99,999 the tax is 15% of income. -If the income is below 50,000, the tax is 10% of income. Your task: Write an IFS formula to calculate the tax due based on the employee's monthly income. Compute the correct tax due for each