Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 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) = £0.00=30/0 = #DIV/0!
    2=ISERR(#VALUE!) = -£1.0010
    3=ISERR(#REF!) = -£1.0020
    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 2013 | 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013