PMT Function
-
How do I use the PMT function?
For example I would like to calculate a payment based on:
fieldname1 = Loan Amount
fieldname2 = Rate
fieldname 3 = term (in months)I would think it would be:
PMT(fieldname2/12,fieldname3,fieldname1)Do I just enter that in the “Set Equation” field or do I have to use:
(function(){ return PMT(fieldname2/12,fieldname3,fieldname1); })()Neither of these seem to work.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘PMT Function’ is closed to new replies.