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!