In cell O2, enter a formula using nested IF functions to calculate the maximum amount of 401(k) contributions that the company will match for an employee. The company’s 401(k) matching plan is based on an employee’s job status (shown in column G) and years of service (shown in column M). Use the following parameters and noted reference types when creating this formula:

A.) If an employee’s Job Status field value is equal to FT, the employee is eligible for the 401(k) matching program. Use a structured reference to the Job Status field in the formula.

B.)If the FT employee also has a Years Service field value greater than or equal to 15, the Max 401(k) Company Match amount is calculated by multiplying the employee’s Current Salary by the value in cell T3. Use structured references to the Years Service and Current Salary fields and an absolute reference to cell T3 in the formula.

C.) If the FT employee does not have a Years Service value greater than or equal to 15, the Max 401(k) Company Match amount is calculated by multiplying the employee’s Current Salary by the value in cell T4. Use structured references to the Years Service and Current Salary fields and an absolute reference to cell T4 in the formula.

D.) If the employee’s Job Status field value is not equal to FT, the formula should return a value of 0.

Answer rating: 100% (QA)

Book1 Microsoft Excel Product Activation Failed File Home Insert P... View the full answer