Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future Value formula
I need a future value formula like this PV(1+r)n=FV. I am trying for this
outcome - 1,000,000(1+1.0)3=8,000,000. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future Value formula
I need a future value formula
=FV(100%,3,,-1000000) (Returns 8,000,000) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "heater" wrote in message ... I need a future value formula like this PV(1+r)n=FV. I am trying for this outcome - 1,000,000(1+1.0)3=8,000,000. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future Value formula
heater wrote:
I need a future value formula like this PV(1+r)n=FV. I am trying for this outcome - 1,000,000(1+1.0)3=8,000,000. The correct way to write that formula is: =1000000*(1+1%)^3 Also, you can use the FV function, to wit: =FV(1%, 3,, -1000000) I ass-u-me you meant 1%, not "1.0", which is 100%. If did indeed intend to write 100%, I suggest that you write "(1+100%)" so that your intent is clear. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Formula to predict a future date | Excel Worksheet Functions |