Pmt formulaes and IFs

Hi Ed

Thanks for your question

Creating too many arguments in a function is indeed a common problem and can have a number of causes. The If function should have three arguments, each separated by a comma, thus there should be two commas in the function.

The best way to avoid this mistake, is where possible to use the paste function tool, (Insert-Function). This will guide you through the process of building the function and will help minimise errors.

Regards

Stephen