Question No 24:
A group of 10 people share the cost of a new year`s eve for 40 friends. The price of the meal per person is £20 plus £4 for wine and £2 for coffee. Calculate the amount each of the 10 will need to pay. Write down a formula which could be input into one cell in Excel to calculate the amount that the 10 will need to pay.
=40*(20+4+2)/10)
No comments:
Post a Comment