Checks whether a value is the #N/A error and returns TRUE or FALSE.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
ISNA(value)The ISNA function is part of the IS family of functions. It specifically identifies the #N/A error, which typically occurs when a lookup function cannot find a matching value. It returns TRUE if the cell contains #N/A, and FALSE for any other value or error type.
=ISNA(NA())Sonuç: TRUE
The NA() function generates the #N/A error, so ISNA returns TRUE.
=ISNA(5)Sonuç: FALSE
Since 5 is not an #N/A error, the function returns FALSE.
No, ISNA only returns TRUE for the #N/A error. Use ISERROR to detect all error types.