Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for Present Value I Can Copy and Paste Safely
Let's say you have an investment that pays out once each year for N years.
The columns of the spreadsheet look like this: Year Payment Present Value I don't know in advance how many years I want to analyze and that could easily change later. How can I construct the present value formula so that it automatically adjusts the range being summed up to year 1 for the number of periods and the payments? I'm trying to avoid having to manually adjust each present value calculation to specify a different range of cells. What would the formula look like that would allow me to easily copy and paste the formula - without needing to tweak it by hand - to new years as the analysis expands? -- Will |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for Present Value I Can Copy and Paste Safely
Pl. look at
http://www.dummies.com/WileyCDA/Dumm...FFICESOFT.html Once you get the formula which refers to the years in Col B simpl copy it down after filling years in Col B "Will" wrote: Let's say you have an investment that pays out once each year for N years. The columns of the spreadsheet look like this: Year Payment Present Value I don't know in advance how many years I want to analyze and that could easily change later. How can I construct the present value formula so that it automatically adjusts the range being summed up to year 1 for the number of periods and the payments? I'm trying to avoid having to manually adjust each present value calculation to specify a different range of cells. What would the formula look like that would allow me to easily copy and paste the formula - without needing to tweak it by hand - to new years as the analysis expands? -- Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Safely sending spreadsheet in e/mail | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Can I safely enter information on two worksheets simultaneously w. | New Users to Excel |