Posting a charge at the first of the month

[bizman]

I have about 3 weeks experience with excell and have set up a simpl
spreadsheet to show customers on a trash collection route. Th
customers rates are not all the same so the amount they pay is in on
column. The amount they have due is in another column and the amoun
paid in another. I need to post the monthly rate to the amount du
column on the first of the month adding it to whatever balance they ma
have and be able to subtract any payments made from the account too. An
ideas how to set thid up? I am just beginning to understand the wa
functions and arrays work from reading the book I bought from thi
site. It is a little hard to learn it overnight though and I sure woul
appreciate and jumpstart I can get

Thanks
Gran

 

[robert111]

jan feb mar
customer b/f cost paid bal b/f cost paid bal b/f
cost paid bal
tom 0 10 0 10 10 10 10 10 10
10 20 0


the balance is b/f plus cost minus paid
the second and subsequent b/f's are set equal to previous balanc
value

 

[bizman]

I appreciate the help but as I mentioned earlier, I am a total newbie t
Excel. Is there some way you could draw me a picture like they do fo
preschool kids. I see what you posted and know what you mean but hav
no idea how to put it into the spreadsheet to make it work. Just thin
of me as someone who does not speak your language at all. (Exce
language) I know, get someone else to do the spreadsheet but then ho
will I learn?

Thanks agai