Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 16:12:04 +0000



Post From: Does ISERROR work?

[2017-08-04 17:56:44]
Jeffrey - Posts: 2195
This is a documentation error. The Spreadsheet Functions page will be updated.

ISERROR does not exist by that name. The function is ISERR, which has the functionality of "Returns TRUE if the given Value is an error value type. Otherwise returns FALSE."

Also do you support IFERROR and IFNA?
IFERROR(A, B, C) can be written as IF(ERR(A), B, C).
IFNA(A, B, C) can be written as IF(A=#N/A, B, C)
imageSpreadsheet example ISERR NA.PNG / V - Attached On 2017-08-04 17:56:03 UTC - Size: 6.55 KB - 304 views