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

ISERR(value)

 
 Returns the boolean value depending if the value is (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!).

 valueThe value that you want to test.

 REMARKS
 
  		• The "value" can refer to a value, text string, cell reference, formula or a named range.
     
  		• This function will not identify cells that contain a #N/A as an error, unlike the ISERROR() function.

     EXAMPLES
     
     AB
    1=ISERR(#N/A) = False=30/0 = #DIV/0!
    2=ISERR(#VALUE!) = True10
    3=ISERR(#REF!) = True20
    4=ISERR(#DIV/0!) = True30
    5=ISERR(#NUM!) = True40
    6=ISERR(#NAME?) = True 
    7=ISERR(#NULL!) = True 
    8=ISERR(B1) = True 
    9=ISERR(B2:B5) = True 
    10=ISERR(B1:B5) = True 
    11=ISERR(50) = False 
    12=ISERR("") = False 
    13=ISERR("some text") = False 
    14=ISERR(named_range) = True 
    		 
     Functions - I | Index - I | Office Online 

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