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

B

7/10/2014

3.5

4/11/1961

55

Bonham

FT

$ 106,010

1

1106

Goode

Bari

B

11/6/2015

2.2

11/23/1991

25

Graham

FT

$ 42,182

1

1110

Reams

Linda

B

12/4/2015

2.1

10/15/1966

50

Bonham

FT

$ 92,254

1

1114

Rodriguez

Richard

D

3/24/2003

14.8

12/8/1964

52

Graham

FT

$ 69,250

Yes

No

3

1118

Peters

Jessica

C

5/23/2011

6.6

2/15/1962

54

Bonham

FT

$ 102,567

Yes

2

Bonus Table

Bonus
A	0
B	300
C	600
D	800