software

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.

gt; I need a future value formula

=FV(100%,3,,-1000000)

(Returns 8,000,000)
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;heaterquot; gt; wrote in message
...
gt;I need a future value formula like this PV(1 r)n=FV. I am trying for this
gt; outcome - 1,000,000(1 1.0)3=8,000,000.
heater wrote:
gt; I need a future value formula like this PV(1 r)n=FV. I am
gt; 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 quot;1.0quot;, which is 100%. If did
indeed intend to write 100%, I suggest that you write quot;(1 100%)quot;
so that your intent is clear.