Spreadsheet: 67878d1268396366-excel2003-alternative-to-if-function-when-dealing-with-more-than-7-ifs-base-rota2
Sheet: Sheet3

 | SUNDAY
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Monday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Tuesday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Wednesday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Thursday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Friday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team
 | Saturday
 |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work |  | Work
 | 8 TO 5 | Area | 10 TO 5 | Area | 11 TO 5 | Area | 12 TO 5 | Area | 12 TO 6 | Area | 1 TO 8 | Area | 2 TO F | Area | 3 TO F | Area | 4 TO F | Area | 5 TO F | Area | 6 TO 9 | Area | 6 TO F | Area
[NAME] | 1 |  | 1 |  | 1 |  | 2 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 5 |  | 0 |  | 0
Rota
Floor
Bar
Both
Total Team