isnum
Syntax:
Value
Boolean
isnum
(
Range
source)
Description:
Return
true
if all cells in
source
are numeric,
false
otherwise.
Examples:
($d1:$d5) = isnum($a:$c)
Before:
A
B
C
D
1
1
4
-
2
apple
1.234
3
five
%
13
4
12
11
-13
5
six
5
2
6
After:
A
B
C
D
1
1
4
-
false
2
apple
1.234
false
3
five
%
13
false
4
12
11
-13
true
5
six
5
2
false
6
($a1) = isnum($b1:$d20)