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

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.

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.