Spreadsheet: 69748d1270374225-nested-if-and-formula-sample1
Sheet: summary

 | Payroll Summary
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 14:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | 10 | 11 | 11 | 15 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 14:40:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | 10 | 11 | 11 | 15 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | Rachel Holt
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | Beverly Wade
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | $7.25 | $7.25 | $7.25 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
 | [NAME]
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:11:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 15 | 10 | 10
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10