If/Or Function Help

I think I have the first part of this solved but can’t seem to figure our the second part with Job Status.

=IF(OR([@[Pay Grade]]=”D”), “No”,””)

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.

 

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        
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 No    
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 No    
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 No    
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 No    
1194 Godrun Earle D 4/20/2007 10.7 6/30/1956 60 Graham FT  $                   94,441 Yes No    
1198 Cannon Ramon D 6/15/2007 10.6 9/29/1950 66 Graham FT  $                   90,338 Yes No    
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 No    
1326 Wilt Thomas D 3/19/2007 10.8 11/7/1982 34 Graham FT  $                   90,283 Yes No    
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 No    
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 No    
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 No    
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 No    
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 No    
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 No    
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 No    
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 No    
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        

By: Kerry

Leave a Reply

Your email address will not be published. Required fields are marked *