Why does my PMT formula say syntax error??!

If you post the formula the people of this forum could help debug it, but it would be better in general to give a bit more detail and a screenshot of your table so that we can see exactly what you have.

The most difficult part is the periodic rate. Is the length of the loan term usually in months so for a five year loan it is 12*5=60. You take your interest rate say 6% and divide it by 60. So .06/60.

The num-periods is 60.

My crystal ball is in the shop so, like Charles, I'll need to see the formula in question. If you click on the yellow triangle in the cell showing the error the text can be helpful.

Have a look at the Mortgage Calculator template for a good example of how PMT (also IPMT) is used.:

You can access the Template Chooser via File > New.

SG

Hi SG,

You can access the Template Chooser via File > New.

Unless you are a Luddite like me, with Numbers > Preferences > For New Documents > Use template

Then you must hold down the good old option key to see 'Menu > File > New' change to 'New From Template Chooser...'

(One of Numbers' best kept secrets 😉).

Regards,

Ian.

Hi Ian,

Aha! I still have my Numbers > Preferences set like this:

So if set instead to 'Use template', then must hold down the option key to see the Chooser.

SG