Forum Discussion
Solved
Families gathering expenses calculation in Excel?
We have 3 families gathers every weekend and play cards and food sharing. So it is difficult to calculate every weekend expenses. Example A, B and C are family. 1st week A spent food = x amount...
itsmesri Perhaps the example in the attached file will help you develop something that suits your need.
itsmesri Perhaps the example in the attached file will help you develop something that suits your need.
this is not telling me payment for games whom to pay to whom. If A need to B - $10 and A need pay to C - $10.
Sometimes B to A - $15 and C-A - $8 like this.
in food also B and C need to pay A - split equal because A paid for food.
itsmesri Just insert rows to indicate who should pay how much to whom, following the logic in the example. A negative means one should receive, a positive means one should pay.