What's the difference between ISERR() and ISERROR()?

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

@Isaiah documentation updated :slightly_smiling_face: Honeycode Functions

Thanks again!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.