ISERR(value)

Returns the value True or False depending if the value is an error (not #N/A).

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.
* You can use the ISBLANK function to return True or False depending if the value is blank.
* You can use the ISERROR function to indicate if the value is an error (including #N/A).
* You can use the ISNA function to return True or False depending if the value is #N/A.
* You can use the ISREF function to return the value True or False depending if the value is a cell reference.
* You can use the ERROR.TYPE function to return the number corresponding to a particular error value in a cell.
* For the Microsoft documentation refer to support.office.com

 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 


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top