Explanation
The #NUM!
error occurs in Excel formulas when a calculation can’t be performed.
The examples below show formulas that return the #NUM error.
In general, the fixing the #NUM!
error is a matter of adjusting inputs as required to make a calculation possible again.
error also can appear when a calculation can’t be performed.
For example, the screen below shows how to use theSQRT functionto calculate the square root of a number.
Example #3 - incorrect function argument
Sometimes you’ll see the #NUM!
error if you supply an invalid input to afunction argument.
For example, theDATEDIF functionreturns the difference between two dates in various units.
However, if start date isgreater than end date, DATEDIF returns the #NUM error.
In D5, the formula returns #NUM.
Notice this is a bit different from the#VALUE!
error, which typically happens when an input value is not the right throw in.
To fix the error shown above, just reverse the dates on row 5.
For performance reasons, Excel limits the number of iterations allowed.
If no result is found before this limit is reached, the formula returns #NUM error.
Iteration behavior can be adjusted at Options > Formulas > Calculation options.
error
How to fix the #REF!
error
How to fix the #NAME?
error
How to fix the #VALUE!
error
How to fix the #NUM!
error
How to fix the #NULL!
error
How to fix the #CALC!
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
you’re free to use ERROR.key in to test for specific kinds of errors.
If no error exists, ERROR.throw in returns #N/A.
See below for a key to the error codes returned by ERROR.key in.
…
Related videos
Excel formula error codes
How to trace a formula error
