Set up for table to calculate "who owes what to who?"

D

djm

I have a spreadsheet that totals expenses and divides them (unequally
among 4 people...A, B, C, D.......I need a set of formulas that wil
calculate what D owes A (and B) if B owes A (or vice versa) more tha
what C owes B etc etc...I have attached a copy of the spreadsheet..i
is small (39KB)...when I enter a payment/expense, it automatically goe
under B's column but I can split it b/w A and B..or enter the sam
number under A's column and it will move it from "paid by B" to "pai
by A".....it totals all expenses and divides them, laying out who owe
whom...the difficult part is transferring $$$ from D to A (or B) if C'
share of expenses isn't enough....kind of hard to explain but if yo
look at the sample (TR sample) it will be clear....thank you for an
help/suggestions that you may have.....you can reply here, or directl
to me at (e-mail address removed)

Attachment filename: tr sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62406
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top