|
Group expense splitting
1 Attachment(s)
Hi, Using the public forums , 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.
|
Group expense splitting
Hi Josef,
Am Thu, 17 Dec 2015 04:32:52 +0000 schrieb Excel Dumbo: +-------------------------------------------------------------------+ |Filename: Friends Expenses Split.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1023| +-------------------------------------------------------------------+ in I5: =IF(VLOOKUP($G5,$B$4:$E$11,4,0)<0,0,MIN(VLOOKUP($G 5,$B$4:$E$11,4,0)-SUM($H5:H5),ABS(VLOOKUP(I$3,$B$4:$E$11,4,0))-SUM(I$4:I4))) and copy to the right and down. Or look he https://onedrive.live.com/redir?resi...=folder%2cxlsm for your workbook (Friends Expenses Split) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Thank you very much claus. Worked perfect
|
| All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com