Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > ERROR.TYPE
 

ERROR.TYPE(error_val)

 
 Returns the number corresponding to a particular error value in a cell.

 error_valThe number indicating the type of error you want:
1 = NULL
2 = DIV/0
3 = VALUE
4 = REF
5 = NAME
6 = NUM
7 = N/A

 REMARKS
 
  		• Although "error_val" can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.
     
  		• If "error_val" is anything else other than 1 to 7 then #N/A is returned.

     EXAMPLES
     
     AB
    1=ERROR.TYPE(#NULL!) = 110
    2=ERROR.TYPE(#DIV/0!) = 2 
    3=ERROR.TYPE(#VALUE!) = 3 
    4=ERROR.TYPE(#REF!) = 4 
    5=ERROR.TYPE(#NAME?) = 5 
    6=ERROR.TYPE(#NUM!) = 6 
    7=ERROR.TYPE(#N/A) = 7 
    8=ERROR.TYPE(B1) = #N/A 
    9=ERROR.TYPE(10) = #N/A 
    10=ERROR.TYPE(3) = #N/A 
    		 
     Functions - E | Index - E | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top