Compound interest is a common item and is =PV*(1+R)^N

R is the rate for the period expressed in terms of N. If N is years then R
is the annual rate. If N is months it is the average monthly rate.

Example: I have an annual rate of 18% and I wish to compute for 9 months.
The R value would be .18/12 or .015 and the formula would be PV*(1+0.015)^9

Another form
=P+(P*EFFECT(EFFECT(k,m)*n,n))

http://support.microsoft.com/default...b;en-us;213907
http://support.microsoft.com/default...b;en-us;141695

Frank T

"jnorton" wrote:

I need a function or formula that can calculate what the interest rate would
be for a number of years.

see

http://www.finaid.org/calculators/co...interest.phtml

for an example.

I need the formula they used to place into excel.