Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Group expense splitting
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.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thank you very much claus. Worked perfect
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting an expense | New Users to Excel | |||
Where is the Data Tools group Help refers to when splitting cells | Excel Worksheet Functions | |||
Help building Group Expense Sheet with Equal Allocation | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
graphs for expense | Charts and Charting in Excel |