Home › Functions › Information › ERROR.TYPE
fx
ERROR.TYPE
Information  ·  Since: Excel 2003  ·  9 languages

Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.

🌐 Translations

English ERROR.TYPE
Deutsch FEHLER.TYP
Français TYPE.ERREUR
Español TIPO.DE.ERROR
Italiano ERRORE.TIPO
Português TIPO.ERRO
Nederlands TYPE.FOUT
Polski NR.BŁĘDU
Русский ТИП.ОШИБКИ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

ERROR.TYPE(error_val)

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.

▶ Examples

=ERROR.TYPE(A2)

Related functions

Copied to clipboard