Spreadsheet: 832003d1686055828-if-statement-with-multiple-criteria-sample-wo-clari55a-
Sheet: Background Data

 | PublicHolidays |  | RepairRevisitOnlyExcUKLow |  | DERespHigh |  | DE_Repair_Low |  | ALLWOTDE |  | RepairandPM
 | 2022-08-29 00:00:00 |  | DE Repair High |  | DE Repair High |  | DE Repair Low |  | DE Repair Medium |  | DE Preventative Maintenance High
 | 2022-09-19 00:00:00 |  | DE Repair High XX |  | DE Repair High XX |  | DE Repair Low XX |  | DE Revisit Medium |  | DE Preventative Maintenance Low
 | 2022-12-26 00:00:00 |  | DE Repair Low |  | DE Repair Very High |  |  |  | DE Repair High |  | DE Preventative Maintenance No Priority
 | 2022-12-27 00:00:00 |  | DE Repair Low XX |  | DE Repair Very High XX |  |  |  | DE Revisit High |  | DE Repair High
 | 2023-01-01 00:00:00 |  | DE Repair No Priority |  |  |  |  |  | DE Repair High XX |  | DE Repair High XX
 | 2023-01-03 00:00:00 |  | DE Revisit High |  |  |  |  |  | DE Revisit High XX |  | DE Repair Low
 | 2023-04-07 00:00:00 |  | DE Revisit High XX |  | AllRepairRevisit |  |  |  | DE Repair Very High |  | DE Repair Low XX
 | 2023-04-10 00:00:00 |  | DE Revisit Low |  | DE Repair High |  |  |  | DE Revisit Very High XX |  | DE Repair No Priority
 | 2023-05-08 00:00:00 |  | DE Revisit Low XX |  | DE Repair High XX |  |  |  | DE Repair Very High XX |  | DE Revisit High
 | 2023-05-01 00:00:00 |  | DE Revisit No Priority |  | DE Repair Low |  |  |  | DE Revisit Very High |  | DE Revisit High XX
 | 2023-05-29 00:00:00 |  | DE Revisit No Priority XX |  | DE Repair Low XX |  |  |  | DE Repair Low |  | DE Revisit Low
 | 2023-08-28 00:00:00 |  | FR Repair Low |  | DE Repair No Priority |  |  |  | DE Repair Low XX |  | DE Revisit Low XX
 | 2023-12-25 00:00:00 |  | FR Repair Medium |  | DE Revisit High |  |  |  |  |  | DE Revisit No Priority
 | 2023-12-26 00:00:00 |  | FR Repair No Priority |  | DE Revisit High XX |  |  |  |  |  | DE Revisit No Priority XX
 |  |  | FR Revisit Low |  | DE Revisit Low |  |  |  |  |  | FR Preventative Maintenance Low
 |  |  | FR Revisit Medium |  | DE Revisit Low XX |  |  |  |  |  | FR Preventative Maintenance Medium
 |  |  | FR Revisit No Priority |  | DE Revisit No Priority |  |  |  |  |  | FR Repair Low
 |  |  | UK Repair High |  | DE Revisit No Priority XX |  |  |  |  |  | FR Repair Medium
 |  |  | UK Repair High XX |  | FR Repair Low |  |  |  |  |  | FR Repair No Priority
 |  |  | UK Repair Medium |  | FR Repair Medium |  |  |  |  |  | FR Revisit Low
 |  |  | UK Repair Medium XX |  | FR Repair No Priority |  |  |  |  |  | FR Revisit Medium
 |  |  | UK Repair Very High |  | FR Revisit Low |  |  |  |  |  | FR Revisit No Priority
 |  |  | UK Repair Very High XX |  | FR Revisit Medium |  |  |  |  |  | UK Preventative Maintenance Low
 |  |  | Uk Revisit High |  | FR Revisit No Priority |  |  |  |  |  | UK Preventative Maintenance Medium
 |  |  | UK Revisit High XX |  | UK Repair High |  |  |  |  |  | UK Repair High
 |  |  | Uk Revisit Medium |  | UK Repair High XX |  |  |  |  |  | UK Repair High XX
 |  |  | UK Revisit Medium XX |  | UK Repair Medium |  |  |  |  |  | UK Repair Low
 |  |  | UK Revisit Very High |  | UK Repair Medium XX |  |  |  |  |  | UK Repair Low XX
 |  |  |  |  | UK Repair Very High |  |  |  |  |  | UK Repair Medium
 |  |  |  |  | UK Repair Very High XX |  |  |  |  |  | UK Repair Medium XX
 |  |  |  |  | Uk Revisit High |  |  |  |  |  | UK Repair Very High
 |  |  |  |  | UK Revisit High XX |  |  |  |  |  | UK Repair Very High XX
 |  |  |  |  | Uk Revisit Medium |  |  |  |  |  | Uk Revisit High
 |  |  |  |  | UK Revisit Medium XX |  |  |  |  |  | UK Revisit High XX
 |  |  |  |  | UK Revisit Very High |  |  |  |  |  | UK Revisit Low
 |  |  |  |  | UK Revisit Low |  |  |  |  |  | UK Revisit Low XX
 |  |  |  |  | UK Revisit Low XX |  |  |  |  |  | Uk Revisit Medium
 |  |  |  |  | UK Repair Low |  |  |  |  |  | UK Revisit Medium XX
 |  |  |  |  | UK Repair Low XX |  |  |  |  |  | UK Revisit Very High