Question: In the Bonus column, enter an If function with a nested VLOOKUP function to calculate the bonus for each employee based on whether the employee

In the Bonus column, enter an If function with a nested VLOOKUP function to calculate the bonus for each employee based on whether the employee is eligible for a bonus (column M) and his or her Pay Grade. The bonus information for qualifying employees is in a table named Bonus in the Sheet2 worksheet.

**Please show work/formula**

Employee ID

Last Name

First Name

Pay Grade

Hire Date

Years of Service

Birth Date

Age

Store

Job Status

Current Salary

Work Anniversary

Eligible for Bonus

Comp Days

Bonus

1102

Delosreyes

Lori

7/10/2014

3.5

4/11/1961

Bonham

$ 106,010

1106

Goode

Bari

11/6/2015

2.2

11/23/1991

Graham

$ 42,182

1110

Reams

Linda

12/4/2015

2.1

10/15/1966

Bonham

$ 92,254

1114

Rodriguez

Richard

3/24/2003

14.8

12/8/1964

Graham

$ 69,250

Yes

1118

Peters

Jessica

5/23/2011

6.6

2/15/1962

Bonham

$ 102,567

Yes

Bonus Table

Bonus
A	0
B	300
C	600
D	800

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In the Bonus column, enter an IF function with a nested VLOOKUP function to calculate the bonus for each employee based on whether the employee is elgible for a bonus (column M) and his or her Pay...

oyees.pdf - Adobe Acrobat Reader DC Help --Case Review ... x PRACTICE Data File needed for the Review Assignments: Employees.xlsx Vanessa wants you to analyze the MBHC employee data to determine each...

1 0 Note: Do NOT use an array formula / function for this step. See Note 8 from Step 1 above. First Resource pays out a bonus to the coordinator of each event based on the type of event, the total...

On the Employee Data worksheet, create a function for the Work Anniversary column that will state Yes if it is the employees work month anniversary and will otherwise be blank. Use the Work...

Complete the following steps on the Employee Data worksheet: 1. In the Years of Service column, use functions to determine how many years each employee has worked at MB Accounting Services. Fill the...

just the formulas please! cell range ex A 2 :A 1 1 3 2 5 . Employees with Years of Service longer than ten will receive Long Service Awards. Use the Logical function to determine who qualifies for...

All employees with one or more years of service are eligible for a bonus. Pay Grade 1 employees receive $ 3 , 0 0 0 ( cell U 2 ) , Pay Grade 2 employees receive $ 6 , 0 0 0 ( cell U 3 ) , and Pay...

this the link you just have to copy and paste it. https://1drv.ms/x/s!AkinDDYoZ7pLgVyZUF1Kr11YFtxY this what you should do? (Excel Table, Copy Worksheet, Sort, Filter, Subtotals, Pivot Table, Pivot...

Dundar Mifflin is considering the purchase of new printer and have narrowed down the possibilities to two models which perform equally well. However, the method of paying for the two models is...

Q. In some cases, persons convicted of white-collar or corporate offenses receive lighter sentences relative to those convicted of street crimes. Someone who is convicted of embezzling 1 million...

The measure of systematic risk in a single stock relative to the average risk in the market is

3. A solution is prepared by dissolving 50.4g sucrose in 0.332kg of water. The final volume of the solution is 355mL. Calculate the molarity, molality, percent by mass, mole fraction, and mole...

What is the purpose of a Position Control Table? What relationships to other Compensation Tables would be important?

What Data Elements are usually found in the Job Family Table, and what is the relationship of the Job Family Table to the Occupation Table?

What is the relationship between the Internal Staff Compensation Target Table and the Internal Staff Compensation Data Table?