>I tried asking is question once upon a time and no one could convert it that is why I choose to call excel now I have a user who does not have excel so we just ignore the calc but they really want to know.
>
>It is calculating an equivilant rate.
>
>=RATE($A$1,-(($B$1+C1)/$A$1),$B$1)*12
>
>A = Term
>B = LoanAmt
>C = Interest
>
>D = EquivRate.
>
>Give it a shot....
Are the A, B, C values in a spreadsheet or are you opening a blank spreadsheet with the function above set for D and letting the user input A, B and C and then see the result in D?