Try

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


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


"C Tate" wrote in message
...
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!