Use help to find the description for the PMT function.
The result should be right because lots of people use it every day.
However, the function may have some limitations. You need to read its help
descritpion.
Pay attention to the TYPE parameter.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"ai18ma" wrote in message
...
Good Day,

How do I get to see the equation behind Excel Functions? For instance, the
result of pmt() is not making sense to me, I'd like to see what this
function
is doing and how it is calculating its value. Trial and Error is rather
time-consuming and tedious. What is the better way of doing this? Thnx for
the help.