Friday 28 April 2017

Excel - Microsoft Error Type

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