Provera greške u rezultatu formule Excel 2010 i noviji



Value     is the argument that is checked for an error.

Value_if_error     is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.


  • If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (“”).
  • If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.



The ERROR.TYPE function syntax has the following arguments:

  • Error_val    Required. The error value whose identifying number you want to find. Although error_val can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.
If error_val is ERROR.TYPE returns
#NULL! 1
#DIV/0! 2
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7
Anything else #N/A