ISERROR(value)

Returns the value True or False depending if the value is an error.


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 identify cells that contain a #N/A as an error.
* You can use the ISERR function to indicate if the value is an error (excluding #N/A).
* For the Microsoft documentation refer to support.office.com

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


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