Excel auto accumulation formulas
in [Functions]
|
Prev: Remove Text From AlphaNumeric
Next: Excel 2003 worksheet tabs missing at bottom of my laptop display
From: Arix on 10 May 2010 22:30 Hi hello, I need a formula for auto accumulation formula like example: John need to give me USD50 everyday for one month, so if he never paid the money i will key in 0.00 in that collumn and the ammount accmulated for today is 50.00 and the next day calculation like USD100, but if he did the payment full i will key in 50.00, if he only pays USD30 i will key in 30.00, so the balanse out standing will shows 30.00 for today and will shows 80.00 on the next day. I need a formula for every single day it auto accumulate USD50. I'm trying alot of formula but none is working. Thank You for you help!!!
From: Jacob Skaria on 11 May 2010 02:41
With data as below...apply the below formula in cell B2..and copy down as required =(COUNT($A$2:A2)*50)-SUM($C$2:C2) Col A Col B Col C Date Pending Actuals 5/11/2010 0 50 5/12/2010 0 50 5/13/2010 0 50 5/14/2010 30 20 5/15/2010 80 5/16/2010 130 5/17/2010 180 5/18/2010 230 5/19/2010 280 5/20/2010 330 5/21/2010 380 5/22/2010 430 5/23/2010 480 5/24/2010 530 5/25/2010 580 -- Jacob (MVP - Excel) "Arix" wrote: > Hi hello, > > I need a formula for auto accumulation formula like example: > > John need to give me USD50 everyday for one month, so if he never paid the > money i will key in 0.00 in that collumn and the ammount accmulated for today > is 50.00 and the next day calculation like USD100, but if he did the payment > full i will key in 50.00, if he only pays USD30 i will key in 30.00, so the > balanse out standing will shows 30.00 for today and will shows 80.00 on the > next day. I need a formula for every single day it auto accumulate USD50. > > I'm trying alot of formula but none is working. Thank You for you help!!! |