Skip to Content

ERROR.TYPE

Returns a number corresponding to an error type

Syntax

ERROR.TYPE(error_val)

Parameters

  • error_val: Required. The error value whose identifying number you want to find (1=#NULL!, 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#NAME?, 6=#NUM!, 7=#N/A, 8=#GETTING_DATA)

Example

=ERROR.TYPE(A1)
Returns: NumberSince: Excel 2003