Money goes "Out" on Feb 20, Feb 21, and Feb 28 . The Money that goes "Out"
on Feb 21, comes back "In" on Feb 27, so that money is back before the money
that goes "Out" on Feb 28, which reduces the total outstanding. The money
that goes "Out" on Feb 20 is not due back "In" until Mar 21, so this total
would still be a running total. The money that comes back "In" before money
goes "Out" is the total that needs to be reduced.

Just think of it as money paid "Out" in day 1 is paid back 7 days from now,
and more money was paid "Out" in day 2 that is due back on day 4, so the
money paid "Out" on day 1 & 2 would be a total, but when day 4 comes, day 2
money is reduced, so day 1 money is still outstanding.

I know this is mind boggling, but I'm sure someone can figure this out, if
you input the info in a spreadsheet maybe it would be more clear. You guys
answer some pretty difficult stuff - take this as a challenge. Thanks for
your help!

"Sandy Mann" wrote:

Perhaps like me people don't understand what it is that you are trying to
do. Although having said that it never ceases to amaze me how the regulars
are able to interpret exactly what posters are really asking.

In your example you have an "Out" on Feb 20 and another "Out" on Feb 21 yet
you only count the Feb 21 "Out" because it is higher up the sheet. Surely
you should count in chronological order?

Can you explain more fully what it is that you are doing then perhaps you
may get an answer.

--
HTH

Sandy

with @tiscali.co.uk

"heater" wrote in message
...
Any help - Can this be done?

"heater" wrote:

I need a formula for money "out" money "In". If the money goes "Out" on
a
specified date and comes "In" at a later date, then it will keep a
running
total of how much money is "Out".

Ex:
B14="Out", D14(Feb 21, 06) E14(-7,650,286) F14(Feb 27,06)
B15="In", D15(Feb 27, 06) E15(7,650,286) F15(Feb 27,06)
B16 ="Out", D16(Feb 20, 06) E16(-2,463,804) F16(Mar 21,06)
B17="In", D17(Mar 21, 06) E17(2,463,804) F17(Mar 21,06)
B18="Out, D18(Feb 28, 06) E18(-2,307,156) F18(Mar 21,06)
B19="In, D19(Mar 21, 06) E19(2,307,156) F19(Mar 21,06)

I have this formula (D14<F14,(E14*0.8),0) in 014, which
equals -6,120,229.
Cell 016=-1,971,043 and cell 018=-1,845,725 - Cell R14:R19 keeps the
total.
So, with the formula I have it just keeps a running total - cell R14 is
-6,120,229, R16 is -8,091,272 and R18 is -9,936,997. I need a formula
that
will reduce the total in Column R once the money is returned. So, for
example after Feb 27, the total in Cell R18 would be 3,816,768
(6,120,229-9,936,997).