+ Reply to Thread
Results 1 to 4 of 4

Need help with formula for expense sharing

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    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
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    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.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-08-2013
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    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. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need help with formula for expense sharing

    Quote Originally Posted by mganesh123 View Post
    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.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1