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??