Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalc needed for successive years
I use WIN98 and Excel. I need to do the following sum on a
worksheet\spreadsheet YEAR ONE My pensions produce an income of A My Savings are B My savings delivering an income of C So my total income is (A+C) Expenditure is D So over the year the surplus\deficit is (A+C)-D I then say E=(A+C)-D If I am receiving more than I spend, then E will be a plus figure, if the other way round, a minus. Problem: I now want for year TWO to add E into my savings figure, either increasing it, if E is a plus, or decreasing it if E is a minus. This in turn increases or decreases the income from my savings. And so on for (say) twenty or thirty successive years. Can I do this on Excel? If so, how? Is this the right newsgroup? If not, which? TIA Mr Warwick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seniority Years Formula needed | Excel Discussion (Misc queries) | |||
How to chart monthly sales for successive years | Charts and Charting in Excel | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
Recalc needed for successive years | Excel Discussion (Misc queries) | |||
Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel |