# Detect errors in EXCEL formulas

### EXCEL Functions: NA

HG()the English version NA(), returns the error value #N/A. the error Value #N/A means that the value is unavailable. We consider the cases when this feature might be useful.

### EXCEL Functions: ISERROR

Function ISERROR(), English version of ISERROR(), preveral on the equality of the values #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL! and returns depending on this TRUE or FALSE.

### EXCEL Functions: ISNA

Function ENA(), the English version of the ISNA(), preveral on the equality of the value of #N/A (value not available) and returns depending on this TRUE or FALSE.

### EXCEL Functions: IFERROR

Function IFERROR(), English version of IFERROR(), preverae the expression on the equality of values #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL! If the test expression or the value in the cell contains an error, the function return is defined for this value, otherwise the evaluation result of an expression, or contents of a cell.

### EXCEL Functions: ISERR

Function ISERR()the English version ISERR(), checks for equality of values: #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL! and returns depending on this TRUE or FALSE.

### Count cells that contain errors in EXCEL

it Happens that the formulas return errors (#of CASES/0!, #N/A, #VALUE! etc.) Calculate the number of cells containing errors.

### Hide error value in EXCEL cell

Sometimes you want to hide the cell error value: #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? Do this a few ways.

### Show calculation steps in Excel

When writing complex formulas, such as =IF(AVERAGE(A2:A10)&gt,200,sum(B2:B10),0), it is often necessary to obtain an intermediate calculation result of the formula. There is a special tool to Calculate the formula.

### Sum Values Ignoring #N/A Error in EXCEL

If the range of summation is found, the error value #N/A (value not available), the function SUM() will return an error. Use the function SUMIF() to handle such situations.

### Excel showing the formula in a cell instead of the resulting value

Sometimes typing the formula and pressing ENTER the user sees in the cell is not the result of the calculation formula and the formula itself. The reason - Text format to the cell. Show how to get the formula to work.