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

After this in Maximum iteration box type how many times you want to excel to recalculate. Remember that if the number of iterations is higher it will take more time to calculate a worksheet. Now look ...

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