ERROR.TYPE Formula in Excel

What Does It Do?

This function will show a number which corresponds to an error produced by a formula.

image

Syntax

=ERROR.TYPE(Error)

Error is the cell reference where the error occurred.

Formatting

The result will be formatted as a normal number.

No comments:

Post a Comment