G
Guest
I would like to know what the actual calc is in PMT.
The commas do not do anything.
The commas do not do anything.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
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.
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.
J
joeu2004
I would like to know what the actual calc is in PMT.
The commas do not do anything.
You question is unclear to me. What specifically do you not
understand about the Help page for PMT?
G
Guest
I don't know what the commas are indicating to do with the variables.
J
joeu2004
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.
M
Micky G
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.??
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.??
N
Niek Otten
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.
| >
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.
| >
J
joeu2004
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.??
Oh, so you would like to know the mathematical formula for computing
the payment. Look at the PV Help page. Solve for "pmt".
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.