Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Convert years to years and days | Excel Discussion (Misc queries) | |||
Data Range Mess | Charts and Charting in Excel | |||
"In Today's Dollars" help needed... | Excel Worksheet Functions | |||
To create formula to add 3 years and subtract 1 day from a date? | Excel Worksheet Functions | |||
I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) |