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.
For companies everywhere, Excel is a must. For individuals it is very useful and adaptable. For people who will use it to almost its full potential, then it is worth learning and investing time and money into training. For individuals who just want to use its simple functions, choose something more basic and less expensive as you will probably never need or use its full capacity. In some ways Excel it is a victim of it’s own success. It is such a powerful tool that it is almost impossible to learn how to use it from a manual or from the help topics provided.