=--TEXT((1+A1/12)^(A2*12)-1,"0.00%")
where A1 holds the yearly rate and A2 holds the number of years


"jnorton" wrote in message
...
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.