When we do something wrong with entering the formula in the Excel cell, Excel will alert us to the error by putting the symbols in the cell. Knowing the common Excel errors will help us understand the problem and correct the formulas we wrote. Let's review the list of Excel formulation errors and their meanings below:

VALUE #:

This error means that you used an incorrect type of data as a formula input. For example, you might have entered a range in a function that takes a parameter of the type of a cell, or in the form where you have to refer to the number of text, instead of the number. For example, in the formula A1 / A2, the value in the cell A2 is a text.

*? NAME #:

This error occurs when you write the wrong name in the formulas, use the text values used in the formula in the "Do not leave" column or leave the empty parentheses associated with the function.

! NUM #: This is a problem with one of the numbers in your formula. For example, the number is very large or very small.

DIV / 0 #: This error indicates that you have divided some formulas from zero. The amount of one of the cells you used in your formula may be zero or missing. Excel does not count the cells in the calculation of zero, and if you divide some numbers into them, this error will be displayed.

! REF #: This error means that you are referring to the cell in the formulas that are not there. This error usually occurs when you delete cells or, for example, copy the formula that is written in relative terms and refers to cell A3, copy the A4 cell of that cell into another A2 cell.

N / A #: This error is usually shown when the value you want is not found. For example, you do not have the required value in a LOOKUP function in any of the range cells that you defined for the function.

! NULL #: This error indicates that you used the distance from the formula where you should use the math symptoms. For example, instead of the formula = A1 + A2 + A3, you mistakenly entered the value = A1 + A2 A3. One of the other reasons why this formula is displayed is that you have somewhere in the formula to specify a range between the two cells of the sign.

########: This mark does not actually represent a formulation error. When this is indicated, the meaning is that Excel could successfully calculate the formula but could not display the calculated value in the cell. To solve this problem, you usually need to increase the width of the column to make the calculated value appear in the column or change the cell format to the appropriate option. For example, if the cell format is of a type, it may be necessary to change it to the number.

## Bookmarks