View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default Equation behind the Function

ai18ma -

For the equation behind PMT (and other annuity financial functions), see the
offline Help for "PV worksheet function."

- Mike
www.mikemiddleton.com

"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.