In the Eligible for Bonus column, enter a fromula with IF and OR functions to display the text No if the employee's pay grade is D or the employee's job status is a part time (PT). Leave the cell blank if the employee is eligible for a bonus.

**Show all work/formulas**

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

1102

Delosreyes

Lori

B

7/10/2014

3.5

4/11/1961

55

Bonham

FT

$ 106,010

1106

Goode

Bari

B

11/6/2015

2.2

11/23/1991

25

Graham

FT

$ 42,182

1110

Reams

Linda

B

12/4/2015

2.1

10/15/1966

50

Bonham

FT

$ 92,254

1114

Rodriguez

Richard

D

3/24/2003

14.8

12/8/1964

52

Graham

FT

$ 69,250

Yes

1118

Peters

Jessica

C

5/23/2011

6.6

2/15/1962

54

Bonham

FT

$ 102,567

Yes

1122

Cortez

Nick

D

8/12/2002

15.4

10/15/1968

48

Bowie

FT

$ 94,517

Yes

1126

Millard

Melissa

B

11/6/2015

2.2

3/20/1973

43

Garland

FT

$ 51,791

1130

Burns

Brenda

C

6/10/2010

7.6

4/20/1966

50

Garland

FT

$ 32,530

Yes

1134

Kimball

Susan

C

1/20/2016

1.9

3/21/1957

59

Graham

FT

$ 94,502

1138

Ford

Charles

A

5/4/2012

5.7

6/28/1967

49

Bonham

PT

$ 45,671

Yes

1142

Vazquez

Johnny

C

7/16/2011

6.5

2/8/1986

30

Graham

FT

$ 70,346

Yes

1146

Whetstone

William

C

4/12/2008

9.7

7/13/1986

30

Garland

FT

$ 34,685

Yes

1150

Arnold

Leroy

C

3/13/2012

5.8

7/8/1949

67

Bonham

FT

$ 96,944

Yes

1154

Basile

Santos

B

8/8/2015

2.4

12/1/1956

60

Bonham

FT

$ 92,091

1158

Loftis

Robert

B

7/17/2015

2.5

7/12/1959

57

Garland

FT

$ 30,150

1162

Olson

Ruth

B

1/8/2015

3.0

3/6/1970

46

Bonham

FT

$ 81,536

1166

Gridley

Marjorie

B

10/4/2013

4.2

10/25/1959

57

Bowie

FT

$ 96,021

Yes

1170

Estevez

Lois

C

9/7/2012

5.3

3/11/1961

55

Garland

FT

$ 58,720

Yes

1174

Cannon

Eva

B

8/7/2014

3.4

10/28/1956

60

Graham

FT

$ 76,947

1178

Tyler

Shirley

B

5/29/2015

2.6

8/21/1950

66

Graham

FT

$ 96,449

1182

Smith

Robin

D

1/18/2007

11.0

11/8/1951

65

Garland

FT

$ 45,766

Yes

1186

Lee

Marvin

B

1/1/2016

2.0

6/10/1966

50

Graham

FT

$ 96,960

1190

Erwin

Erin

D

1/8/2004

14.0

12/23/1991

25

Graham

FT

$ 94,346

Yes

1194

Godrun

Earle

D

4/20/2007

10.7

6/30/1956

60

Graham

FT

$ 94,441

Yes

1198

Cannon

Ramon

D

6/15/2007

10.6

9/29/1950

66

Graham

FT

$ 90,338

Yes

1302

Chavez

Jason

A

6/15/2012

5.5

7/31/1963

53

Graham

PT

$ 49,890

Yes

1306

Poulsen

Catherine

B

7/10/2015

2.5

5/5/1960

56

Graham

FT

$ 68,681

1310

Lunsford

Alberta

C

1/22/2016

1.9

7/11/1953

63

Graham

FT

$ 52,244

1314

Marciano

Kathy

B

10/16/2015

2.2

7/15/1984

32

Graham

FT

$ 92,221

1318

Miller

Billy

B

8/28/2015

2.3

11/24/1951

65

Graham

FT

$ 35,304

1322

Ward

Deann

D

9/22/2006

11.3

1/5/1959

57

Bowie

FT

$ 51,675

Yes

1326

Wilt

Thomas

D

3/19/2007

10.8

11/7/1982

34

Graham

FT

$ 90,283

Yes

1330

Young

Alfonso

A

3/11/2010

7.8

3/3/1958

58

Garland

PT

$ 45,657

Yes

1334

Maddox

Nicole

B

8/28/2015

2.3

2/5/1976

40

Bowie

FT

$ 39,545

1338

Escarcega

Michael

D

8/11/2003

14.4

4/2/1967

49

Graham

FT

$ 125,068

Yes

1342

Mizer

Joseph

B

4/3/2015

2.7

2/22/1967

49

Graham

FT

$ 80,407

1346

Larsen

Jennifer

C

3/7/2009

8.8

2/15/1965

51

Bonham

FT

$ 83,415

Yes

1350

Jackson

Edwin

C

12/29/2011

6.0

4/4/1953

63

Garland

FT

$ 75,037

Yes

1354

Keefer

Cynthia

C

3/12/2016

1.8

3/20/1979

37

Garland

FT

$ 53,826

1358

Melancon

Dina

B

6/7/2015

2.6

5/8/1976

40

Garland

FT

$ 38,083

1362

Foley

Pamela

C

1/22/2016

1.9

4/2/1991

25

Bowie

FT

$ 54,945

1366

Jean

Carlos

B

10/30/2015

2.2

4/27/1956

60

Graham

FT

$ 104,494

1370

Neace

Marc

B

9/4/2015

2.3

11/7/1974

42

Bowie

FT

$ 71,446

1374

Swanson

Brandon

A

10/12/2013

4.2

1/17/1970

46

Graham

PT

$ 49,598

Yes

1378

Simpkins

James

C

2/12/2010

7.9

7/12/1974

42

Graham

FT

$ 42,664

Yes

1382

Lavalee

James

C

7/16/2011

6.5

6/11/1970

46

Garland

FT

$ 55,551

Yes

1386

Beals

Vanesa

B

10/2/2015

2.2

6/10/1968

48

Bowie

FT

$ 125,235

1390

Pearce

James

C

2/14/2008

9.9

3/1/1953

63

Garland

FT

$ 51,065

Yes

1394

Gurganus

Esther

D

8/24/2004

13.4

8/11/1966

50

Graham

FT

$ 53,186

Yes

1398

Toomer

Katherine

B

6/19/2015

2.5

11/25/1963

53

Graham

FT

$ 63,491

2002

Mortimer

John

C

5/24/2010

7.6

9/6/1966

50

Graham

FT

$ 108,705

Yes

2006

Allen

Elizabeth

B

8/28/2014

3.3

12/15/1985

31

Bonham

FT

$ 75,818

2010

Smith

Helen

B

4/24/2015

2.7

9/24/1968

48

Bonham

FT

$ 46,142

2014

Rodriguez

Stephen

B

7/18/2014

3.5

8/9/1959

57

Graham

FT

$ 84,036

2018

Thompson

Lane

B

8/21/2015

2.4

7/15/1950

66

Graham

FT

$ 68,470

2022

O'Donnell

Robert

B

3/5/2015

2.8

5/2/1958

58

Bonham

FT

$ 93,248

2026

Spaulding

Sherri

B

3/1/2013

4.8

12/7/1977

39

Bonham

FT

$ 101,822

Yes

2030

McKeown

Michael

B

12/8/2015

2.1

12/4/1961

55

Graham

FT

$ 38,420

2034

Benham

Paul

A

8/11/2011

6.4

1/10/1959

57

Graham

PT

$ 53,582

Yes

2038

Laboy

Jayma

C

6/12/2009

8.6

1/30/1942

74

Garland

FT

$ 24,373

Yes

2042

Casas

Antolin

C

5/4/2012

5.7

8/27/1989

27

Garland

FT

$ 65,181

Yes

2046

Guyer

Ian

B

12/18/2015

2.0

1/6/1968

48

Bowie

FT

$ 71,020

2050

Ramos

Robert

C

5/4/2011

6.7

4/28/1958

58

Garland

FT

$ 60,129

Yes

2054

Dunton

Robert

D

11/26/2004

13.1

10/4/1971

45

Graham

FT

$ 64,845

Yes

2058

Wall

Diana

C

2/22/2008

9.9

1/4/1960

56

Garland

FT

$ 49,831

Yes

2062

Weaver

Leanne

B

12/4/2015

2.1

9/16/1970

46

Graham

FT

$ 76,706

2066

Jung

Brenda

B

10/12/2015

2.2

12/2/1985

31

Garland

FT

$ 91,240

2070

Merritt

Vernon

B

12/4/2015

2.1

5/9/1959

57

Bonham

FT

$ 96,282

2074

Parham

Jose

C

11/26/2010

7.1

5/10/1966

50

Graham

FT

$ 85,412

Yes

2078

Hutton

Patrice

B

3/19/2013

4.8

8/31/1973

43

Graham

FT

$ 98,341

Yes

2082

Davis

Carla

D

6/18/2004

13.5

10/14/1952

64

Graham

FT

$ 93,243

Yes

2086

Griffin

Robert

B

7/21/2015

2.4

11/3/1965

51

Bowie

FT

$ 130,886

2090

Merrill

Shannon

A

11/27/2014

3.1

6/8/1952

64

Bowie

PT

$ 64,826

2094

Blackshear

Gregory

C

4/19/2016

1.7

4/11/1962

54

Graham

FT

$ 76,677

2098

Palmer

Angel

C

7/5/2008

9.5

3/17/1959

57

Graham

FT

$ 46,566

Yes

3002

Fallis

Ruth

C

6/3/2010

7.6

6/16/1953

63

Bonham

FT

$ 89,391

Yes

3206

Montoya

Maria

C

1/29/2016

1.9

11/1/1982

34

Graham

FT

$ 54,368

3210

Bennett

James

C

8/2/2010

7.4

7/26/1962

54

Garland

FT

$ 36,671

Yes

3214

Web

Jason

B

8/28/2015

2.3

9/24/1974

42

Graham

FT

$ 58,309

3218

Whiting

Jeffery

D

11/5/2007

10.2

5/31/1951

65

Garland

FT

$ 37,090

Yes

3222

Lloyd

Shanika

A

7/17/2015

2.5

10/15/1984

32

Garland

PT

$ 51,639

3226

Baker

Ina

C

7/1/2010

7.5

10/9/1991

25

Garland

FT

$ 59,138

Yes

3230

Rosenberg

Robert

B

7/17/2015

2.5

2/1/1949

67

Bowie

FT

$ 114,254

3234

George

Robert

A

3/13/2011

6.8

5/12/1969

47

Graham

PT

$ 64,598

Yes

3238

Trottier

James

B

7/24/2015

2.4

10/25/1959

57

Graham

FT

$ 94,896

3242

Elamin

Martin

B

2/5/2014

3.9

1/18/1947

69

Graham

FT

$ 58,291

3246

Pope

Richard

C

3/15/2009

8.8

3/3/1961

55

Garland

FT

$ 58,161

Yes

3250

Burgess

Charlotte

D

11/11/2005

12.1

5/13/1978

38

Graham

FT

$ 99,539

Yes

3254

Floyd

Bobbi

B

9/12/2014

3.3

9/24/1986

30

Graham

FT

$ 102,609

3258

Guerrero

Maudie

D

9/18/2006

11.3

6/16/1953

63

Graham

FT

$ 52,125

Yes

3262

Roeder

Larry

B

11/13/2015

2.1

10/11/1955

61

Graham

FT

$ 94,452

3266

Joe

Ronald

B

12/11/2014

3.1

3/3/1974

42

Graham

FT

$ 97,543

3270

Holland

Patricia

C

5/13/2010

7.6

6/5/1959

57

Bonham

FT

$ 98,219

Yes

3274

Parham

Theresa

A

11/26/2013

4.1

3/2/1955

61

Graham

PT

$ 41,204

Yes

3278

Williamson

Santina

A

8/25/2004

13.4

5/13/1964

52

Bowie

PT

$ 65,978

Yes

3280

Bennett

June

A

9/6/2008

9.3

6/26/1967

49

Bowie

PT

$ 96,354

Yes

3282

Wolfe

Larry

D

11/20/2004

13.1

11/2/1950

66

Graham

FT

$ 38,683

Yes

3286

Bradley

Thomas

B

4/10/2015

2.7

7/15/1982

34

Bonham

FT

$ 77,468

3294

Martinez

John

C

10/17/2009

8.2

3/20/1967

49

Bonham

FT

$ 111,426

Yes

3298

Bean

Douglas

B

5/29/2015

2.6

4/15/1953

63

Graham

FT

$ 95,552