• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Friends Expense Split Model

Hi, Using the public forums in here , I managed to partly build up a file that helps to split costs among friends. But I will need further help completing this. Please refer attached.
 

Attachments

  • Friends Expenses Split.xls
    37.5 KB · Views: 8
@Ecel Dumbo... Interesting question. To be fair, your model doesn't look versatile. May be it is work in progress.

Assuming you have the information about how many each person should receive in the cells I2:K2,

You can use below formula in cell I5. Copy paste it in the range I2:K11 to get rest of the results.

=IF($E5>0,MAX(0,MIN(I$2-SUM(I$4:I4),$E5-SUM($H5:H5))),0)

Essentially, we allocate the amount due in E5 (Sam - $4.5) until we run out of the money Sam has to pay.

See attached file.

Here is a tutorial (almost 8 years old) to help you with more: http://chandoo.org/wp/2008/01/25/how-to-sharing-trip-expenses-using-excel/
 

Attachments

  • Friends Expenses Split.xls
    41 KB · Views: 5
Back
Top