The excel formula uses function to perform calculation ie. RATE. You have to change the number of times excel performs or iterates formulas. Go to Formula tab, under calculation option check Enable ...

You have to change the number of times excel performs or iterates formulas. Go to Formula tab, under calculation option check Enable iterative calculation box. After this in Maximum iteration box type ...

In this article, we're talking about what #num means in Excel, its causes and everything else you need to know.

Knowing how to fix common Excel errors like #DIV/0!, #REF!, and #NUM! can help you quickly resolve problems and save valuable time while working on your spreadsheets.

Microsoft Office Add-ins Documentation. Contribute to OfficeDev/office-js-docs-pr development by creating an account on GitHub.