What Are Excel Formula Errors?

3.8 min read|Last Updated: January 11th, 2024|Categories: excel|
table of content

When using any software, we may encounter various errors, and Excel is no exception in this. When we make a mistake entering the formula in an Excel cell, Excel warns us about the error by placing symbols in the cell. Knowing common Excel errors helps us understand the problem and correct the formulas we have written. In this blog, we will discuss these errors and the reason each of them occurs.

#VALUE

This error appears when you use an unexpected or wrong type of data as the input of the formula. For instance, you have given a text to a mathematical function, or a number to a text function.

Example: #VALUE error in B4 has appeared because cell B3 contains the text “a.”

value error in Excel

As another example, we can see that MINUTE function returns #VALUE error because it can’t extract the minute from the text “a.”

value error in Excel

#NAME

Excel assumes that any unrecognized string which is not the name of a function is a name range, and when it doesn’t recognize a name range, #NAME error appears. This error occurs when you misspell a function name in the formula, do not enter the text values used in the formula into the mark “, or leave blank parentheses for the function.

Example: #NAME error appeared in A4 because the AVERAGE function is misspelled “average.”

Excel NAME erro

#NUM

This error occurs when your numeric value is not valid. It is too large, too small, or the calculation is not possible. For instance, when you have used a function that made a loop and Excel can’t finish the calculation.

Example: #NUM error occurred because “-4” is not valid for the SQRT function.

Num error in Excel

#DIV/0

This error indicates that your formula is dividing by zero or an empty cell. Excel considers empty cells as zero, and if you divide a number by an empty cell, this error appears.

Example: As can be seen below