How to fix #num error in Excel in Windows 10/8/7 [Steps]

Tips to fix #num error in Excel in Windows 10/8/7:

In this post helped you on How to fix #num error in Excel in Windows 10/8/7. You will be guided with easy steps/methods to resolve the issue. Let’s starts the discussion.

‘#num error in Excel’: #num error is common Excel error usually occurred in Excel formulas when a calculation can’t be performed. This error indicates the Excel formula you are trying to apply to a CELL in your Excel worksheet is unable to execute properly and hits #num error instead of correct results you want in that CELL.

For example, when you try to calculate the square root of a negative number or trying to solve other mathematical problem in wrong way, you will receive #num error in Excel instead of the correct result you want to see in the CELL in the Excel Worksheet. There could be several reasons behind the #num error including the faculty numbers, impossible calculation on number you input in CELL/CELL Range, and the iteration formula can’t find valid result.

#num error in Excel occurs when you entered the number either it is too big or too small. If you are not aware, Excel has limits on smallest and largest numbers users can use. If the number you enter is out of this range, you will receive #num error in Excel. This issue can also be occurred if you are trying to perform impossible calculation in your Excel sheet in your Windows computer. For example, when you perform wrong formula, you will get #num error in Excel.

Another possible reason behind the #num error can be the iterative formula that performs same calculations repeatedly. IRR performs calculations cyclically until the result is accurate to within 0.00001%. If IRR can’t find a valid result after 20 attempts, you will receive #num error in Excel. Let’s go for the solution.

How to fix #num error in Excel in Windows 10/8/7?

Method 1: Check your number and formulas again, and correct them

This issue can be occurred if you enter wrong number or formula in CELL/CELL Range. You should check you are entering the number that doesn’t breaks smallest & largest number limit of Excel.

Method 2: Change the number of times Excel iterates formulas

This issue can be occurred due to iteration formula that can’t find valid result.

Step 1: Open ‘Microsoft Excel or MS Excel’ in your Windows PC and go to ‘File > Options’

Step 2: Click ‘Formulas’ tab, check ‘Enable iterative calculation’ box under ‘Calculation’ options

Step 3: Type large number in Maximum Iteration box. The higher number of iterations, the more time Excel needs to calculate the worksheet

Step 4: Enter the amount of change you can accept between calculation results in Maximum Change box. You should keep the number as small as possible.

Method 3: Empty the CELL and then enter the number or correct the formulas

One possible way to fix the issue is to empty the CELL that is given #num error in Excel and then re-enter correct number in the Cell. Also, make sure you are entering correct formula in the CELL/CELL Range and if not, you can empty the CELL in which you enter formula and then re-enter the formula in correct way.


I am sure this post helped you on How to fix #num error in Excel in Windows PC with several easy steps/methods. You can read & follow our instructions to do so. That’s all. For any suggestions or queries, please write on comment box below.