Posted to microsoft.public.excel.worksheet.functions
|
|
nper function calculation
http://groups.google.com/group/micro...fc88f222?hl=en
Dana DeLouis wrote:
Hi. Given the equation for PV, and assuming type=0, then NPER equals:
=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"bigfella" wrote in message
...
Hi everyone, does anyone know the formulae behind the NPER function in
excel
|