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

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

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.

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

In Microsoft Excel, a handful of errors can appear in your cells, such as Ref, null, Num, Value, etc. Why do spreadsheets have errors? Like most programs, errors can be triggered in Microsoft Word.