Menu
EXCEL ERROR TYPE FUNCTION
Excel ERROR TYPE Function Introduction
The ERROR.TYPE Function belongs to the Information category. The function returns a value that correlates to an error value. If no errors are found, it will return #N/A.
We may utilise this to evaluate a certain error value when performing financial analysis.
ERROR.TYPE can also be used to display a customised error message. The IF function may be used to do this. Instead of returning the error value, the IF function may be used to test for an error value and return a text string, such as a message.
Description of Excel ERROR TYPE Function
Syntax:
=ERROR.TYPE(error_val)
Parameter list:
- Error value (mandatory parameter) – We want to get the identification number for the error value.
- Though error val can be the actual error number, it is more often than not a reference to a cell holding the formula we wish to test.
Step By Step Guide of ERROR TYPE Function
Example:
Now we’d want to enter a personalised message. What we want is for this formula to examine the provided cell reference, i.e. cell A2, to see if it contains either the #NULL! or the #DIV/0! error value.
If mistakes are discovered, the error value number is utilised in the CHOOSE worksheet function to show one of two.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
