Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Information > ERROR.TYPE
 

ERROR.TYPE(error_val)

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

 error_valThe error or formula that returns the error you want to identify.

 REMARKS
 
  		• Although "error_val" can be the actual error value, it will typically be a reference to a cell containing a formula.
     
  		• If "error_val" evaluates to anything other than an error, then #N/A is returned.
     
  		• If "error_val" evaluates to #NULL!, then 1 is returned.
     
  		• If "error_val" evaluates to #DIV/0!, then 2 is returned.
     
  		• If "error_val" evaluates to #VALUE!, then 3 is returned.
     
  		• If "error_val" evaluates to #REF!, then 4 is returned.
     
  		• If "error_val" evaluates to #NAME?, then 5 is returned.
     
  		• If "error_val" evaluates to #NUM!, then 6 is returned.
     
  		• If "error_val" evaluates to #N/A, then 7 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 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top