mlc@aten.cca.rok.com (Michael Cook) (01/08/91)
I tried posting this last month, but I don't know whether it got sent
since I didn't receive any responses. (Yes, I'm a new user.)
If there is no easy solution, I'd like to know that, too.
Question: Is there an easy way to have the "Year-to-Date" (YTD) values
automatically calculated based on entering new values in the
"This month" cells? This is a kind of spread-sheet circularity.
Currently, I enter the "This month" value, then manually add the new
value and the old YTD value to produce the new YTD value, which I then
manually enter into the spread-sheet.
I have tried using the value of some "key" cell to trigger the YTD
addition, so that when the key cell is blank no update is done, and
when it is set to 1 the update is done. For example, C3 becomes
C3 + C2 when the key cell is 1, and stays C3 otherwise.
I'd like the solution to work when spread-sheet calculation is turned
on, so I don't have to turn it off/on as I enter this month's values.
I am using AppleWorks 2.0 on a IIc.
Example spread-sheet:
1 2 3 4 ....
A This month Year-to-Date
B
C Item 1 $ 123.45 $ 567.32
D Item 2 $ 43.20 $ 102.45
E etc.
F ....
G ======== ========
H Totals: @SUM(A2...G2) @SUM(A3...G3)
Thanks for any tips,
Michael Cook
Internet: mlc%gva.decnet@consrt.rok.com
"Post no bills"