Home : IsBlank
Q11221 - INFO: IsBlank
IsBlank tests whether a value (typically a cell) is blank or empty.  Returns 1 when blank, 0 otherwise.

SYNTAX:

IsBlank(value)

Value: A cell reference or spread function to test if blank.


 

EXAMPLES:

IsBlank(C3) - Returns 1 if nothing is in cell C3.

Download Example Template: Help_Is_Functions.ss3 (Click here for download instructions)

Related Articles
No Related Articles Available.

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 5/10/2008 3:25 PM.
Last Modified on 5/10/2008 3:25 PM.
Last Modified by Scott Dorner.
Article has been viewed 2355 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article