View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
mich mich is offline
external usenet poster
 
Posts: 13
Default mathematical formula of rate

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