Solve Excel problem (3)
(3 votes, average: 3.67 out of 5)
Loading ...The School Board offers 3 coffees per day to all teachers.
If the teacher drinks per week more than 3 coffees in 2 or less days, he has to pay 2 euros for each of those days.
If the teacher drinks per week more than 3 coffees for more than 3 days, he has to pay 5 euros for each of those days.
Pay attention to the example:
| A | B | C | D | E | F | G | |
| 1 | Monday | Tuesday | Wednesday | Thursday | Friday | ||
| 2 | Charles | 3 | 3 | 3 | 3 | 3 | Charles pays 0 euros |
| 3 | Thelma | 3 | 3 | 4 | 3 | 3 | Thelma pays 2 euros |
| 4 | Hugo | 4 | 4 | 2 | 4 | 2 | Hugo pays 15 euros |
| 5 | Yuri | 4 | 4 | 4 | 4 | 4 | Yuri pays 25 euros |
| 6 | Sophie | 2 | 2 | 3 | 4 | 3 | ??? |
Help the School Board by posting the Excel Formula in G6.