| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and paste financial formulas
I am building a financial forecast and have 10 columns representing years 1-10.
Functions such as IPMTand PPMT use the same base parameters such as PV, Rate, NPer etc. and and in the forecast each builds on the results of the year before. How can I copy and paste the first year's formula into a row for each of the remaining years and have the formula refer to its base parameters w/out editing every formula's parameters over and over again? XP 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste a formulas | Excel Worksheet Functions | |||
| How do I copy and paste formulas between workbooks? | Excel Discussion (Misc queries) | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
| How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Threaded Mode
