Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Primitive Functions : ISNUMBER
Q11543 - INFO: ISNUMBER

ISNUMBER (Primitive Spread Function) tests for numeric data.

SYNTAX:

ISNUMBER(value)

REMARKS:

Returns 1 (True) if the value argument is or refers to a number. Returns 0 (False) if the argument is or refers to a value that is not a number.

You might want to use the ISNUMBER function to test whether cells contain numeric data before you perform mathematical operations on them, such as averaging the cells' contents. 

EXAMPLES:

ISNUMBER(B3)
ISNUMBER(12) = 1 (True)

Related Articles
Q11542 - INFO: ISNONTEXT
Q11546 - INFO: ISTEXT

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/26/2008 2:52 PM.
Last Modified on 8/26/2008 2:52 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2521 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article