Description
Use this function to check if a cell contains a numeric value, or that the result of another function is a number. Supported in Chains.
語法
ISNUMBER(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 |
|---|---|
| 紅色 | 56 |
| 綠色 | 39 |
| 橙色 | 15 |
| 紅色 | 92 |
| 藍色 | 22 |
Sample formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=ISNUMBER(A1) |
Checks whether the value in cell A1 is a number. | FALSE |
=ISNUMBER(B1) |
Checks whether the value in cell B1 is a number. | TRUE |
=ISNUMBER(A1+B1) |
Checks whether the sum of cells A1 and B1 is a number. | FALSE |
附註
- Cell ranges aren't supported.
- ISNUMBER returns TRUE for cells containing dates and times.
- ISNUMBER returns FALSE for empty cells, cells containing text, and errors.
Related functions
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
ISBLANK
ISERROR
ISNA
ISNUMBER
VALUE