=A1*(1+C1)^B1

A1 is investment, B1 is number of periods, C1 is intrest percentage (as a
fraction, so 0.05 or 5%)

--
Kind regards,

Niek Otten

"John C." wrote in message
...
This function works for a future value of payments. I simply have an
amount
and I want to calculate the future value with interest compounded.

ljc

"Niek Otten" wrote:

Look in HELP for the FV() function

--
Kind regards,

Niek Otten

"John C." wrote in message
...
How can i calculate the future value of an investment in excel?