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 ...

The #NUM error occurs in your Excel spreadsheet when a function or formula contains invalid numeric values. Remove #NUM errors this way!

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.