=RATE(5,0,-1000,1500)

gives 8.45%


--
Kind regards,

Niek Otten

"Peter" wrote in message
...
On Sun, 11 Dec 2005 20:22:57 +0100, "Niek Otten"
wrote:

Hi Peter,

Look at the RATE() function

See HELP for details


Hi Nic,

Thanks very much for your suggestion - I've tried it, but can't get it
to work. The help example seems to refer to a loan that is being paid
back on a monthly basis.

I have a sum of money, invested on a date, say 1 April and want to
know what the rate of growth on that sum has been over 5 yrs.