About Microsoft Excel

Implementing the PMT Function using Excel Help

Home Back Next

Most people believe that the help provided  in Microsoft Excel is useless. How this notion has got popular is beyond any logic if you research the details carefully. Let's take a careful look at the help feature in Microsoft Excel in connection with the function PMT.
When you start writing '=PMT(  ' you immediately see the following as shown in the image below:

pmt function

First of all you can see all the parametrs that you need to enter to calculate the equal monthly instalments. Now if you bring your mouse cursor next to PMT you can see a link and when you click on it you get the following screen. I've taken many screen shots to show how extensive the help feature in MS Excel is:
excel help 1

excel help 2

excel help 3

excel help 4

So you see the help is pretty good. Not only that. If you now go to the edit group in the Home tab and click on the drop down arrow next to 'Autosum' and finally click on  'More Functions...' you'll be brought to a new window called insert function.
Now enter 'PMT' or 'equal monthly payments' under the title 'search for a function' in the text box.
Next click on Go.
Now you can see the PMT function. Click on it. A screen shot is shown below:
\excel help 5

Now click on ok and youll see the following window:

excel help 6

In this window you get help on each of the parameters Rate, Nper, Pv, Fv and Type with detailed explanations as you see in the case of Rate in the image. In fact as you enter the parameters you can view the result and even correct your entries if you made a mistake.

We can only conclude that the help provided in Microsoft Excel is good and useful.

Home Back Next