Detect errors in EXCEL formulas

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.

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.

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.

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.

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.

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

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

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.

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.

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.