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!!!