thanks tushar the site below was very helpfull

"Tushar Mehta" wrote:

In article ,
says...
what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess); how can
we calculated on paper?


See http://www.aemsinc.com/fincalc/fincalc-how.html though I don't know how
long that page will be available.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions