| LOGIC FORMULAS |
| 1. In column M, if the employee is from Virginia, then enter a "1" in column M, otherwise enter a "0" |
| 2. In column N, if the employee's salary is less than 60, then place the salary in the cell in column N, otherwise do not enter anything (leave blank). |
| 3. In column O, if the employee has a master's degree and more than 4 years of professional experience then place the the employee ID in the corresponding O cell, otherwise place "No promotion" |
| 4. In column P, if the employee is in the Finance/Accounting department or Sales department, place "1" in the corresponding cell, otherwise place a "0" (zero). |
| Name | Title | Title Code | Employee ID | Job Series | Salary in $1000 | Degree | Degree Code | Yrs. Prof. Experience | Home State | Work Schedule | Rank | Logic Formula 1 | Logic Formula 2 | Logic Formula 3 | Logic Formula 4 |
| Uniform | Mr. | 1 | 51585 | Software Development | $39 | Bachelor's | 2 | 0 | Maryland | Full Time | Developer |
| Sierra | Ms. | 2 | 31684 | IT | $44 | Bachelor's | 2 | 2 | Maryland | Full Time | IT Specialist |
| Foxtrot | Ms. | 2 | 27981 | Software Development | $45 | Bachelor's | 2 | 5 | Delaware | Full Time | Developer |
| Mike | Ms. | 2 | 12037 | Finance/Accounting | $47 | Bachelor's | 2 | 4 | Virginia | Full Time | Analyst |
| Whiskey | Ms. | 2 | 76744 | Software Development | $47 | Bachelor's | 2 | 1 | New York | Full Time | Developer |
| Oscar | Mr. | 1 | 62958 | Finance/Accounting | $48 | Bachelor's | 2 | 3 | New York | Full Time | Analyst |
| X-ray | Mr. | 1 | 31811 | Software Development | $52 | Bachelor's | 2 | 2 | Delaware | Full Time | Developer |
| Quebec | Ms. | 2 | 34441 | Software Development | $52 | Bachelor's | 2 | 3 | Maryland | Full Time | Developer |
| Juliet | Ms. | 2 | 82912 | IT | $55 | Bachelor's | 2 | 6 | New York | Full Time | IT Specialist |
| Delta | Mr. | 1 | 96689 | Software Development | $56 | Bachelor's | 2 | 4 | Virginia | Full Time | Developer |
| Papa | Ms. | 2 | 10641 | Finance/Accounting | $61 | Bachelor's | 2 | 6 | Maryland | Full Time | Manager |
| Echo | Ms. | 2 | 29584 | Finance/Accounting | $62 | Bachelor's | 2 | 4 | Virginia | Full Time | Analyst |
| Lima | Ms. | 2 | 49776 | Software Development | $68 | Bachelor's | 2 | 5 | Delaware | Full Time | Developer |
| India | Ms. | 2 | 47611 | Sales | $68 | Bachelor's | 2 | 8 | New York | Full Time | Representative |
| Hotel | Ms. | 2 | 24581 | Sales | $71 | Bachelor's | 2 | 5 | New York | Full Time | Manager |
| Golf | Ms. | 2 | 13302 | Analytics | $85 | Bachelor's | 2 | 7 | New York | Full Time | Senior Staff |
| November | Mr. | 1 | 47389 | Software Development | $39 | High School | 1 | 4 | Delaware | Full Time | Developer |
| Victor | Mr. | 1 | 44791 | Software Development | $41 | High School | 1 | 5 | Maryland | Full Time | Developer |
| Romeo | Ms. | 2 | 73891 | Finance/Accounting | $49 | High School | 1 | 3 | Maryland | Full Time | Analyst |
| Yankee | Mr. | 1 | 26138 | Software Development | $59 | Master's | 3 | 1 | Maryland | Full Time | Manager |
| Bravo | Ms. | 2 | 96491 | CIO | $135 | Master's | 3 | 20 | Virginia | Full Time | Senior Staff |
| Charlie | Mr. | 1 | 76850 | CFO | $143 | Master's | 3 | 26 | Virginia | Full Time | Senior Staff |
| Alpha | Mr. | 1 | 96572 | CEO | $155 | Master's | 3 | 18 | New York | Full Time | CEO |
oguzhansaglik
QuizSP21_BGD522.xlsx
