ExcelHeroThe ISNUMBER function
Checks whether a value is a number.
In German Excel: ISTZAHL
How to write it
=ISNUMBER(value)- value
- A cell or a formula to check.
💡 ISNUMBER(SEARCH("x",A2)) tells you whether A2 contains “x”.
Try it
Is the reading in B3 a real number?
A
B
C
1
Sensor
Reading
Number?
2
S1
12
3
S2
error
4
S3
15
=ISNUMBER(cell) is TRUE for numbers only.