The documentation says ISERR(value) tests for an error value, and ISERROR(value) tests for any error value. What's the difference?
Hello @Isaiah, good observation and catch. There is a subtle difference between the two: ISERR(value) returns TRUE if the value refers to or evaluates to an error value except #N/A; while ISERROR(value) returns TRUE if value refers to or evaluates to any error value, including #N/A.
A quick and easy demonstration is if you are in a table you can try the following:
=ISERR(#N/A) -> FALSE
=ISERROR(#N/A) -> TRUE
That being said, I think we could be a bit more clear in our docs, so I'll put in a request to add this subtly.
Thanks!
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.