Description
The Excel Error.Type function receives an error value and returns an integer, that tells you the type of the supplied error.
The syntax of the function is:
ERROR.TYPE( error_val )
Where the supplied error_val is a value (or a reference to a cell containing a value), that you want to return the error type of.
The integers returned by the Excel Error.Type function, and their corresponding error types are listed in the table below:
Error.Type Function Examples
Column B of the following spreadsheet shows four examples of the Error.Type function.
No comments:
Post a Comment