View Single Post
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

What are the answers you get in each environment.

FWIW, I calculate my mortgage payments using PMT and they are correct.

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"punkyh" wrote in message
...
I am trying to get a monthly payment figure by using the payment formula

in
excel. It always calculates the payment incorrectly. I try it on my
financial calculator, as well as a financial program I have in the

computer
and these two come up with the same figure. Then I try it in excel, the
answer is different.

the formula I am using is: =PMT(.0015,360,375,000)

Any help??