Ecel Dumbo
Member
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.
Friends Expense Split Model
- Thread starter Ecel Dumbo
- Start date
@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/
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/
Ecel Dumbo
Member
Thank you very much Chandoo