🔢 Error Decoder

Goal: Identify the specific type of error.
ERROR.TYPE converts error symbols into numbers (1-8) so you can react to them differently.

#ERR
DIAGNOSTIC RESULT
--
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7
Ready...

💻 Formula Structure

=ERROR.TYPE(error_val)
  • Input: The cell containing the error.
  • Returns: A number (1-8) corresponding to the error type.
  • Note: Returns #N/A if the cell contains NO error.
-- Check error type in A1
=ERROR.TYPE( A1 )
Error Code:
-

⚠️ Practical Use

💡 Custom Messages
Combine with IF/CHOOSE to give specific advice:
=IF(ERROR.TYPE(A1)=7, "Item not found", "Check math").
🚫 No Error?
If the cell does not contain an error, ERROR.TYPE itself returns the #N/A error! Always wrap it in IFERROR or check ISERROR first.