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 version | Available |
| Excel 2007 |
✓ |
| Excel 2013 |
✓ |
| Excel 2019 |
✓ |
| Excel 2021 |
✓ |
| Microsoft 365 |
✓ |
Translate a formula with this function
⌨ 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)