Description
Use this function to return TRUE when a cell contains the #N/A error, and FALSE for any other value or any other error type. Supported in Chains.
語法
ISNA(value)
Inputs
This function has the following arguments:
| 名稱 | 必要 | 說明 | Valid Input |
|---|---|---|---|
值 |
是 |
The cell that you want to evaluate. | A reference to a cell, or a formula which results in one. |
範例
範例資料
| A | B |
|---|---|
| #N/A | 56 |
| 綠色 | 39 |
| 橙色 | 15 |
| 紅色 | 92 |
| 藍色 | 22 |
Sample formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=ISNA(A1) |
Evaluates if cell A1 contains a #N/A error response. | TRUE |
=ISNA(B1) |
Evaluates if cell B1 contains a #N/A error response. | FALSE |
附註
- Cell ranges aren't supported.
- ISNA returns FALSE for all values and errors other than
#N/A.
提示
- You can combine ISNA with the IF function to test for #N/A and display a friendly message if the error occurs.
For example, to display a message if A1 contains #N/A and the value of A1 if not:=IF(ISNA(A1),"friendly message",A1
- The IFNA function is a more efficient way to trap the #N/A error.
Related functions
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
ISBLANK
ISERROR
ISNA
ISNUMBER
VALUE