software

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!
Try

=PV(B5,B6,0,B7,0)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;C Tatequot; gt; wrote in message
...
gt;I have a spreadsheet in which I have an annual rate of interest
gt;(b5 which is 5%), number of years investment (b6 which is 3) and
gt;a future value in b7 (7,800,000 euros). What is the best way to
gt;find out the present value of the investment? I am trying to use
gt;the pv function but am a bit lost!
gt;