mathematical formula of rate

what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess);
i have the pmt, the number of payments, and the present value i need to
calculate the rate on paper

use the function RATE to calculate interest rate for constant payment loan

it is detailed in help, PV worksheet function

Hi Robert

Have a look at this web page for additional info
http://techonthenet.com/excel//formulas/rate.php

hello robert111,
thanks for the information it was helpfull, but i need to calculate the rate
in this formula:
pmt= pv * i / 1 - (1/(1+i)^n)
where i=rate, n=period, pmt=annuity, pv=present value
i=?

"robert111" wrote:

>
> it is detailed in help, PV worksheet function
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=558796
>
>

i = (PMT*(1-(1+i)^n))/pv