Syntax

ERROR.TYPE(error_val)

The ERROR.TYPE function syntax has the following arguments:

Microsoft Office For Mac Support Phone Number

If error_val is
ERROR.TYPE returns
#NULL!
1
#DIV/0!
2
#VALUE!
3
#REF!
4
#NAME?
5
#NUM!
6
Microsoft office recovery files location mac. #N/A
7
#GETTING_DATA
8
Anything else
#N/A

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Does Mac Support Microsoft Office

Data
#NULL!
#DIV/0!
Formula
Description
Result
=ERROR.TYPE(A2)
Number of the #NULL! Error(1).
1
=IF(ERROR.TYPE(A3)<3,CHOOSE(ERROR.TYPE(A3),'Ranges do not intersect','The divisor is zero'))
Checks cell A3 to see whether the cell contains either the #NULL! error value or the #DIV/0! error value. If it does, then the number for the error value is used in the CHOOSE worksheet function to display one of two messages; otherwise, the #N/A error value is returned.
The divisor is zero