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 Grade. The bonus information for qualifying employees is in a table named Bonus_Table

Bonus_Table
A	0
B	300
C	600
D	800

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		No	3
1118	Peters	Jessica	C	5/23/2011	6.6	2/15/1962	54	Bonham	FT	$ 102,567			2
1122	Cortez	Nick	D	8/12/2002	15.4	10/15/1968	48	Bowie	FT	$ 94,517		No	3
1126	Millard	Melissa	B	11/6/2015	2.2	3/20/1973	43	Garland	FT	$ 51,791			1
1130	Burns	Brenda	C	6/10/2010	7.6	4/20/1966	50	Garland	FT	$ 32,530			2
1134	Kimball	Susan	C	1/20/2016	1.9	3/21/1957	59	Graham	FT	$ 94,502			1
1138	Ford	Charles	A	5/4/2012	5.7	6/28/1967	49	Bonham	PT	$ 45,671		No	2
1142	Vazquez	Johnny	C	7/16/2011	6.5	2/8/1986	30	Graham	FT	$ 70,346			2
1146	Whetstone	William	C	4/12/2008	9.7	7/13/1986	30	Garland	FT	$ 34,685	Yes		2
1150	Arnold	Leroy	C	3/13/2012	5.8	7/8/1949	67	Bonham	FT	$ 96,944			2
1154	Basile	Santos	B	8/8/2015	2.4	12/1/1956	60	Bonham	FT	$ 92,091			1
1158	Loftis	Robert	B	7/17/2015	2.5	7/12/1959	57	Garland	FT	$ 30,150			1
1162	Olson	Ruth	B	1/8/2015	3.0	3/6/1970	46	Bonham	FT	$ 81,536			1
1166	Gridley	Marjorie	B	10/4/2013	4.2	10/25/1959	57	Bowie	FT	$ 96,021			1
1170	Estevez	Lois	C	9/7/2012	5.3	3/11/1961	55	Garland	FT	$ 58,720			2
1174	Cannon	Eva	B	8/7/2014	3.4	10/28/1956	60	Graham	FT	$ 76,947			1
1178	Tyler	Shirley	B	5/29/2015	2.6	8/21/1950	66	Graham	FT	$ 96,449			1
1182	Smith	Robin	D	1/18/2007	11.0	11/8/1951	65	Garland	FT	$ 45,766		No	3
1186	Lee	Marvin	B	1/1/2016	2.0	6/10/1966	50	Graham	FT	$ 96,960			1
1190	Erwin	Erin	D	1/8/2004	14.0	12/23/1991	25	Graham	FT	$ 94,346		No	3
1194	Godrun	Earle	D	4/20/2007	10.7	6/30/1956	60	Graham	FT	$ 94,441	Yes	No	3
1198	Cannon	Ramon	D	6/15/2007	10.6	9/29/1950	66	Graham	FT	$ 90,338		No	3
1302	Chavez	Jason	A	6/15/2012	5.5	7/31/1963	53	Graham	PT	$ 49,890		No	2
1306	Poulsen	Catherine	B	7/10/2015	2.5	5/5/1960	56	Graham	FT	$ 68,681			1
1310	Lunsford	Alberta	C	1/22/2016	1.9	7/11/1953	63	Graham	FT	$ 52,244			1
1314	Marciano	Kathy	B	10/16/2015	2.2	7/15/1984	32	Graham	FT	$ 92,221			1
1318	Miller	Billy	B	8/28/2015	2.3	11/24/1951	65	Graham	FT	$ 35,304			1
1322	Ward	Deann	D	9/22/2006	11.3	1/5/1959	57	Bowie	FT	$ 51,675		No	3
1326	Wilt	Thomas	D	3/19/2007	10.8	11/7/1982	34	Graham	FT	$ 90,283		No	3
1330	Young	Alfonso	A	3/11/2010	7.8	3/3/1958	58	Garland	PT	$ 45,657		No	2
1334	Maddox	Nicole	B	8/28/2015	2.3	2/5/1976	40	Bowie	FT	$ 39,545			1
1338	Escarcega	Michael	D	8/11/2003	14.4	4/2/1967	49	Graham	FT	$ 125,068		No	3
1342	Mizer	Joseph	B	4/3/2015	2.7	2/22/1967	49	Graham	FT	$ 80,407	Yes		1
1346	Larsen	Jennifer	C	3/7/2009	8.8	2/15/1965	51	Bonham	FT	$ 83,415			2
1350	Jackson	Edwin	C	12/29/2011	6.0	4/4/1953	63	Garland	FT	$ 75,037			2
1354	Keefer	Cynthia	C	3/12/2016	1.8	3/20/1979	37	Garland	FT	$ 53,826			1
1358	Melancon	Dina	B	6/7/2015	2.6	5/8/1976	40	Garland	FT	$ 38,083			1
1362	Foley	Pamela	C	1/22/2016	1.9	4/2/1991	25	Bowie	FT	$ 54,945			1
1366	Jean	Carlos	B	10/30/2015	2.2	4/27/1956	60	Graham	FT	$ 104,494			1
1370	Neace	Marc	B	9/4/2015	2.3	11/7/1974	42	Bowie	FT	$ 71,446			1
1374	Swanson	Brandon	A	10/12/2013	4.2	1/17/1970	46	Graham	PT	$ 49,598		No	1
1378	Simpkins	James	C	2/12/2010	7.9	7/12/1974	42	Graham	FT	$ 42,664			2
1382	Lavalee	James	C	7/16/2011	6.5	6/11/1970	46	Garland	FT	$ 55,551			2
1386	Beals	Vanesa	B	10/2/2015	2.2	6/10/1968	48	Bowie	FT	$ 125,235			1
1390	Pearce	James	C	2/14/2008	9.9	3/1/1953	63	Garland	FT	$ 51,065			2
1394	Gurganus	Esther	D	8/24/2004	13.4	8/11/1966	50	Graham	FT	$ 53,186		No	3
1398	Toomer	Katherine	B	6/19/2015	2.5	11/25/1963	53	Graham	FT	$ 63,491			1
2002	Mortimer	John	C	5/24/2010	7.6	9/6/1966	50	Graham	FT	$ 108,705			2
2006	Allen	Elizabeth	B	8/28/2014	3.3	12/15/1985	31	Bonham	FT	$ 75,818			1
2010	Smith	Helen	B	4/24/2015	2.7	9/24/1968	48	Bonham	FT	$ 46,142	Yes		1
2014	Rodriguez	Stephen	B	7/18/2014	3.5	8/9/1959	57	Graham	FT	$ 84,036			1
2018	Thompson	Lane	B	8/21/2015	2.4	7/15/1950	66	Graham	FT	$ 68,470			1
2022	O'Donnell	Robert	B	3/5/2015	2.8	5/2/1958	58	Bonham	FT	$ 93,248			1
2026	Spaulding	Sherri	B	3/1/2013	4.8	12/7/1977	39	Bonham	FT	$ 101,822			1
2030	McKeown	Michael	B	12/8/2015	2.1	12/4/1961	55	Graham	FT	$ 38,420			1
2034	Benham	Paul	A	8/11/2011	6.4	1/10/1959	57	Graham	PT	$ 53,582		No	2
2038	Laboy	Jayma	C	6/12/2009	8.6	1/30/1942	74	Garland	FT	$ 24,373			2
2042	Casas	Antolin	C	5/4/2012	5.7	8/27/1989	27	Garland	FT	$ 65,181			2
2046	Guyer	Ian	B	12/18/2015	2.0	1/6/1968	48	Bowie	FT	$ 71,020			1
2050	Ramos	Robert	C	5/4/2011	6.7	4/28/1958	58	Garland	FT	$ 60,129			2
2054	Dunton	Robert	D	11/26/2004	13.1	10/4/1971	45	Graham	FT	$ 64,845		No	3
2058	Wall	Diana	C	2/22/2008	9.9	1/4/1960	56	Garland	FT	$ 49,831			2
2062	Weaver	Leanne	B	12/4/2015	2.1	9/16/1970	46	Graham	FT	$ 76,706			1
2066	Jung	Brenda	B	10/12/2015	2.2	12/2/1985	31	Garland	FT	$ 91,240			1
2070	Merritt	Vernon	B	12/4/2015	2.1	5/9/1959	57	Bonham	FT	$ 96,282			1
2074	Parham	Jose	C	11/26/2010	7.1	5/10/1966	50	Graham	FT	$ 85,412			2
2078	Hutton	Patrice	B	3/19/2013	4.8	8/31/1973	43	Graham	FT	$ 98,341			1
2082	Davis	Carla	D	6/18/2004	13.5	10/14/1952	64	Graham	FT	$ 93,243		No	3
2086	Griffin	Robert	B	7/21/2015	2.4	11/3/1965	51	Bowie	FT	$ 130,886			1
2090	Merrill	Shannon	A	11/27/2014	3.1	6/8/1952	64	Bowie	PT	$ 64,826		No	1
2094	Blackshear	Gregory	C	4/19/2016	1.7	4/11/1962	54	Graham	FT	$ 76,677	Yes		1
2098	Palmer	Angel	C	7/5/2008	9.5	3/17/1959	57	Graham	FT	$ 46,566			2
3002	Fallis	Ruth	C	6/3/2010	7.6	6/16/1953	63	Bonham	FT	$ 89,391			2
3206	Montoya	Maria	C	1/29/2016	1.9	11/1/1982	34	Graham	FT	$ 54,368			1
3210	Bennett	James	C	8/2/2010	7.4	7/26/1962	54	Garland	FT	$ 36,671			2
3214	Web	Jason	B	8/28/2015	2.3	9/24/1974	42	Graham	FT	$ 58,309			1
3218	Whiting	Jeffery	D	11/5/2007	10.2	5/31/1951	65	Garland	FT	$ 37,090		No	3
3222	Lloyd	Shanika	A	7/17/2015	2.5	10/15/1984	32	Garland	PT	$ 51,639		No	1
3226	Baker	Ina	C	7/1/2010	7.5	10/9/1991	25	Garland	FT	$ 59,138			2
3230	Rosenberg	Robert	B	7/17/2015	2.5	2/1/1949	67	Bowie	FT	$ 114,254			1
3234	George	Robert	A	3/13/2011	6.8	5/12/1969	47	Graham	PT	$ 64,598		No	2
3238	Trottier	James	B	7/24/2015	2.4	10/25/1959	57	Graham	FT	$ 94,896			1
3242	Elamin	Martin	B	2/5/2014	3.9	1/18/1947	69	Graham	FT	$ 58,291			1
3246	Pope	Richard	C	3/15/2009	8.8	3/3/1961	55	Garland	FT	$ 58,161			2
3250	Burgess	Charlotte	D	11/11/2005	12.1	5/13/1978	38	Graham	FT	$ 99,539		No	3
3254	Floyd	Bobbi	B	9/12/2014	3.3	9/24/1986	30	Graham	FT	$ 102,609			1
3258	Guerrero	Maudie	D	9/18/2006	11.3	6/16/1953	63	Graham	FT	$ 52,125		No	3
3262	Roeder	Larry	B	11/13/2015	2.1	10/11/1955	61	Graham	FT	$ 94,452			1
3266	Joe	Ronald	B	12/11/2014	3.1	3/3/1974	42	Graham	FT	$ 97,543			1
3270	Holland	Patricia	C	5/13/2010	7.6	6/5/1959	57	Bonham	FT	$ 98,219			2
3274	Parham	Theresa	A	11/26/2013	4.1	3/2/1955	61	Graham	PT	$ 41,204		No	1
3278	Williamson	Santina	A	8/25/2004	13.4	5/13/1964	52	Bowie	PT	$ 65,978		No	3
3280	Bennett	June	A	9/6/2008	9.3	6/26/1967	49	Bowie	PT	$ 96,354		No	2
3282	Wolfe	Larry	D	11/20/2004	13.1	11/2/1950	66	Graham	FT	$ 38,683		No	3
3286	Bradley	Thomas	B	4/10/2015	2.7	7/15/1982	34	Bonham	FT	$ 77,468	Yes		1
3294	Martinez	John	C	10/17/2009	8.2	3/20/1967	49	Bonham	FT	$ 111,426			2
3298	Bean	Douglas	B	5/29/2015	2.6	4/15/1953	63	Graham	FT	$ 95,552			1