Excel Comparison
ISERROR vs ISERR vs ISNA in Excel and Google Sheets
ISERR is false for #N/A. An XLOOKUP miss and NA() were FALSE for ISERR here, TRUE for ISERROR and ISNA; #DIV/0! and #VALUE! went the other way.
#isna
1 tutorial tagged “isna”.
1 tutorial tagged “isna”.
ISERR is false for #N/A. An XLOOKUP miss and NA() were FALSE for ISERR here, TRUE for ISERROR and ISNA; #DIV/0! and #VALUE! went the other way.