Knowledgebase: Microsoft Excel
The Easy Way to Recall the Syntax of an Excel Function.
Posted by - NA - on 30 March 2006 07:48 AM
Solution:
If you have trouble rembering the syntax of Excel function, try this:
Type the function's name and then press + + A, which will paste in "dummy" arguments. For example, if you type =pmt into a cell and then press + + A.
You will get the formula=PMT(rate, nper, pv, fv, type).
Replaceing the dummy arguments with the actual arguments will then generate the calculation you need.
(136 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion