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) |
Spreadsheet example ISERR NA.PNG / V - Attached On 2017-08-04 17:56:03 UTC - Size: 6.55 KB - 304 views |