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

Thanks
Grant


--
bizman
------------------------------------------------------------------------
bizman's Profile: http://www.excelforum.com/member.php...o&userid=32727
View this thread: http://www.excelforum.com/showthread...hreadid=525625