urgent work need it within 4 hours
Humtum
Supporting_Document1.xlsxSimple If Statement
| Date | age | pocket_money | pocket_money (alternative) | |||
| 8/28/17 13:57 | 5 | 2 | 2 | |||
| 8/28/17 18:30 | 5 | 2 | 2 | |||
| 8/29/17 18:31 | 5 | 2 | 2 | |||
| 8/28/17 13:57 | 6 | 8 | 8 | |||
| 8/28/17 18:30 | 6 | 8 | 8 | |||
| 8/29/17 18:31 | 6 | 8 | 8 | |||
Nested IF statement
| Date | age | hour | minute | time of day | pocket_money | pocket_money (alternative) | pocket_money(penalty) | pocket_money(penalty) - alternative | ||||||
| 8/28/17 13:57 | 5 | 13 | 57 | day time | 2 | 2 | 2 | 2 | ||||||
| 8/28/17 18:30 | 5 | 18 | 30 | day time | 2 | 2 | 2 | 2 | ||||||
| 8/29/17 18:31 | 5 | 18 | 31 | night time | 2 | 2 | 3 | 3 | ||||||
| 8/28/17 13:57 | 6 | 13 | 57 | day time | 8 | 8 | 8 | 8 | ||||||
| 8/28/17 18:30 | 6 | 18 | 30 | day time | 8 | 8 | 8 | 8 | ||||||
| 8/29/17 18:31 | 6 | 18 | 31 | night time | 8 | 8 | 9 | 9 | ||||||
