What are the calcs in PMT

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Micky,

In a blank worksheet, type

=PMT(

then pess CTRL+A

this gives (should give) you the function wizard, in which you can press "help on this function"

If this doesn't help you enough, post again in this same thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to know what the actual calc is in PMT.
| The commas do not do anything.
 
I would like to know what the actual calc is in PMT.
The commas do not do anything.
Click to expand...

You question is unclear to me. What specifically do you not
understand about the Help page for PMT?
 
I don't know what the commas are indicating to do with the variables.
Click to expand...

Consider this example from the Help page:

=PMT(A2/12, A3, A4)

The commas simply separate the list of arguments, much like commas
separate the following list of languages: English, French, German,
Italian. The commas serve no other purpose. They "do" nothing to the
arguments.

That should be "obvious". So I suspect I am not understanding your
question. If I failed to answer your question, please provide a
specific example.
 
I understand the %/months a year, I understand the content of the chosen
cells but what is being done with the contents in them. They are obviously
not being added together, what's the calculation between the rate, number of
payments and the principal amoiunt.??
 
Hi Micky,

In my reply, 5 days ago, I advised you to look at the HELP pages. So did joeu2004.
I don't think you've done that; if you did, you'd have found the reference to the PV function, which gives a detailed explanation
of the calculations.

Please follow our advice. Post again with details if you still have problems.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I understand the %/months a year, I understand the content of the chosen
| cells but what is being done with the contents in them. They are obviously
| not being added together, what's the calculation between the rate, number of
| payments and the principal amoiunt.??
|
|
| "joeu2004" wrote:
|
| > > I don't know what the commas are indicating to do with the variables.
| >
| > Consider this example from the Help page:
| >
| > =PMT(A2/12, A3, A4)
| >
| > The commas simply separate the list of arguments, much like commas
| > separate the following list of languages: English, French, German,
| > Italian. The commas serve no other purpose. They "do" nothing to the
| > arguments.
| >
| > That should be "obvious". So I suspect I am not understanding your
| > question. If I failed to answer your question, please provide a
| > specific example.
| >
 
I understand the %/months a year, I understand the content of the chosen
cells but what is being done with the contents in them. They are obviously
not being added together, what's the calculation between the rate, number of
payments and the principal amoiunt.??
Click to expand...

Oh, so you would like to know the mathematical formula for computing
the payment. Look at the PV Help page. Solve for "pmt".
 
Back
Top