Excel Budget

[Greg]

Hi
I hope someone can help.

Is the following possible with Excel?
Entering multiple values in one cell, which will
automatically calculate the value.
eg. Buying CDs on the first day of the month, we spend =
$10.00 (this value is entered into cell A1); The same
purchase is made 10 times during the same month, but the
values may be different. I want to automatically
calculate the value by adding the previous value $10
(Cell A1) with future values ($5; $25; $1; etc).
Hope you understand my question.

Cheers
Greg

 

[Paul B]

Greg, why not put this in A1 =SUM(A2:A100) and then put your amounts in A2,
A3 ..... this way you will have a record of the purchases you make and A1
will keep the totals for you
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Paul B]

Greg, But if you want to do it in one cell have a look at J.E. McGimpsey's
page here http://www.mcgimpsey.com/excel/accumulator.html


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **