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.