H
heater
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).
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).