Checks whether a value is the #N/A error and returns TRUE or FALSE.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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())Результат: TRUE
The NA() function generates the #N/A error, so ISNA returns TRUE.
=ISNA(5)Результат: 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.