Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Book1 Microsoft Excel Product Activation Failed File Home Insert P... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Java Programming, Comprehensive Version

Authors: Y. Daniel Liang

10th Edition

133761312, 978-0133761313

More Books

Students also viewed these Accounting questions