# Need help with formula for expense sharing

1. ## Need help with formula for expense sharing

I was trying to create a formula for expense sharing between three friends. Though it looked to be simple at first, it does not appear to be.

Overall requirement: When three people contribute different amounts for an expense item than their actual share, how can we come up with a formula which shows what amounts need to be exchanged between them for a reconciliation? Attaching the excel sheet. I was looking to fill out the cells in yellow with formulae.

Ganesh

2. ## Re: Need help with formula for expense sharing

Why not do it as simple as this. It is quite obvious who has to pay who.

3. ## Re: Need help with formula for expense sharing

Hi,

Yes, this is really simple :-) Thanks and my problem is actually solved. Just out of academic interest, if the group were to be more than 3, then we might need some interesting formulae to be applied I guess.

Ganesh

4. ## Re: Need help with formula for expense sharing

Originally Posted by mganesh123
Hi,

Yes, this is really simple :-) Thanks and my problem is actually solved. Just out of academic interest, if the group were to be more than 3, then we might need some interesting formulae to be applied I guess.

Ganesh
Rambo4711's solution would work for any number of people. It doesn't matter who specifically owes who. Everyone pays into or extracts money from one reconciliation pool.

There are currently 1 users browsing this thread. (0 members and 1 guests)