Hi Peter,

Look at the RATE() function

See HELP for details

--
Kind regards,

Niek Otten

"Peter" wrote in message
...
an anyone please advise how I may do the following?

A sum of money is invested for 5 years - at the end of that 5 years
interest is paid ( a known amount)

How can I work out what rate of interest has been paid if no
withdrawals have been made i.e the rate of compound interest paid.
--
Cheers

Peter