View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Present value and future value

Errata....

On Apr 7, 5:33 am, "joeu2004" wrote:
=round(pmt((1+5%)/(1+4%)-1, 2, -25000, 0, 1)
[....]
=round(pmt((1+5%)/(1+3%)-1, 30, -100000, 0, 1)


Well, at least my typos are consistent ;-). Of course, those should
be:

=round(pmt(...), 0)