More help!

[C Tate]

I have a spreadsheet in which I have an annual rate of interest (b5 which is
5%), number of years investment (b6 which is 3) and a future value in b7
(7,800,000 euros). What is the best way to find out the present value of the
investment? I am trying to use the pv function but am a bit lost!

[Chip Pearson]

Try

=PV(B5,B6,0,B7,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"C Tate" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet in which I have an annual rate of interest
>(b5 which is 5%), number of years investment (b6 which is 3) and
>a future value in b7 (7,800,000 euros). What is the best way to
>find out the present value of the investment? I am trying to use
>the pv function but am a bit lost!
>