Returns a number corresponding to an error type.
ไวยากรณ์
ERROR.TYPE(error_val)อาร์กิวเมนต์
error_valจำเป็น
The error value you want to identify.
The ERROR.TYPE function returns a specific integer that identifies the type of error in a cell. If the referenced cell does not contain an error, the function returns the #N/A error value.
=ERROR.TYPE(#DIV/0!)→2Returns 2 because #DIV/0! is the second error type in the system.
=ERROR.TYPE(#N/A)→7Returns 7 because #N/A is the seventh error type.
Select a cell
Click on the cell where you want to display the error code.
Enter the formula
Type =ERROR.TYPE(A1) where A1 contains the error you are testing.
The function returns the #N/A error value.