Home : ISBLANK
Q10707 - INFO: ISBLANK

ISBLANK returns 1 if the value of the specified variable is BLANK (empty) and 0 otherwise. 

SYNTAX:

ISBLANK(Cx)
where :
Cx is a conditional variable x

NOTES:

This function REQUIRES a Cx type variable reference, the Vx variable reference will not work.

EXAMPLES:

V88 = ISBLANK(C71)

In this example, variable 88 will be 1 if variable 71 is empty, and 0 if variable 71 holds a value:

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...
Maybe we should add information on how this works when isblank is put into an if statement. 1s and 0s are not involved if you just use something like =if(isblank(c2),v600,v601)or have a link to the math toolbox if statement KB and explain it there. Approved: 6/28/2012 1:44 PM
Created on 2/5/2008 3:08 PM.
Last Modified on 2/5/2008 3:08 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2942 times.
Rated 8 out of 10 based on 1 vote.
Print Article
Email Article