The ISNUMBER function checks whether a value is a number, returning the logical value True in positive case or the logical value False in negative case.
Syntax
ISNUMBER(
value
)
Parameters
- value: Value to evaluate.
Returned value
The ISNUMBER function returns a Boolean.
Examples
In this simple example we check whether 5.3 is a number or not:
In this second example, it is checked whether the text "a" is a number or not:
Next, it is checked whether the sum of the SalesAmount field of the Sales table is a number or not:
Category
Information
