According to Help, it is an iterative calaculation: guess one value, calc, guess another, calc, and
based on the results of the first two, guess a third, and continue.... That's why we use Excel
rather than paper and pencil to do these sorts of things.

HTH,
Bernie
MS Excel MVP


"mich" wrote in message
...
hello bernie,
i would like to know if i have all the arguments except the rate, how can i
calculate it on paper
if
pmt= pv * i / 1 - (1/(1+i)^n)
where i=rate, n=period, pmt=annuity, pv=present value
i=?



"Bernie Deitrick" wrote:

From Help:

Microsoft Excel solves for one financial argument in terms of the others. If rate is not 0, then:



HTH,
Bernie
MS Excel MVP


"mich" wrote in message
...
what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess); how can
we calculated on paper?