Results 1 to 4 of 4

Need help with formula for expense sharing

Threaded View

  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

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