undefinedundefined
I am trying to build a Spreadsheet that will allow me to distribute costs equally to all members of the group for vacation purposes. For instance, if there are 10 members, and one group member pays $100, and another pays $50, and the rest of the group does not contribute. That means that each member is required to pay $15, but b/c members 1 & 2 already paid, they are entitled to reimbursement. What I want to be able to calculate is how much each person in the group owes the other people. Obviously person one is entitled to $85 and member 2 is entitled to $35, but I want to show where these funds are coming from.

I apologize if this is not the right forum as this is my first post. I genuinely appreciate any help, and if further clarfication is needed please advise.

Thank you.

Jeremy