Difference between revisions of "Manuals/calci/ISBLANK"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISBLANK'''(Value) where, '''Value''' -  represents the cell. </div> ---- <div id="1SpaceContent" clas...")
 
 
(8 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''ISBLANK (Value)'''</div><br/>
 +
*<math>Value</math> is the value to test.
 +
**ISBLANK(), returns TRUE if the value is blank.
  
−
'''ISBLANK'''(Value)
+
==Description==
 +
*This function is  one of the group in ISFUNCTIONS.
 +
*The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
 +
*ISBLANK function can be used to check for blank or null values.
 +
*This function will return the result as TRUE when given value or referred cell is empty otherwise the result is FALSE when the cell is nonempty.
 +
*The argument can be blank, or it can contain data such as text, numbers, error values, or logical values.
  
−
where,
+
==Examples==
−
 
+
{| class="wikitable"
−
'''Value''' -  represents the cell.
+
|+Spreadsheet
−
 
+
|-
−
</div>
+
! !! A !! B !! C !! D
−
----
+
|-
−
<div id="1SpaceContent" class="zcontent" align="left">If cell is empty, ISBLANK returns 1.</div>
+
! 1
−
----
+
| 121|| abc || 12/1/2012 ||
−
<div id="7SpaceContent" class="zcontent" align="left">
+
|-
−
 
+
|}
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
ISBLANK
+
#=ISBLANK(A1)=FALSE
 +
#=ISBLANK(B1)=FALSE
 +
#=ISBLANK(C1)=FALSE
 +
#=ISBLANK(D1)=TRUE
  
−
</div></div>
+
==Related Videos==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row2)
+
{{#ev:youtube|Nd0JfLStYG8|280|center|ISBLANK}}
  
−
<nowiki>=ISBLANK(R1C1)</nowiki>
+
==See Also==
 +
*[[Manuals/calci/ISLOGICAL  | ISLOGICAL ]]
 +
*[[Manuals/calci/ISTEXT  | ISTEXT ]]
  
−
ISBLANK returns 0.
+
==References==
 +
*[http://en.wikipedia.org/wiki/Is_functions  Is Function]
  
−
Cosider an another example
 
  
−
<nowiki>=ISBLANK(C2)</nowiki>
 
  
−
It returns 1.
 
  
−
</div>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="  " | Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="  " | 5
 
−
| class="sshl_f " | 0
 
−
| 0
 
−
| 0
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 0
 
−
| class="sshl_f" | 1
 
−
| 0
 
−
| 0
 
−
|- class="odd"
 
−
| Row3
 
−
| 0
 
−
| class="            SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| 0
 
−
| 0
 
−
|- class="even"
 
−
| Row4
 
−
| 0
 
−
| 0
 
−
| 0
 
−
| 0
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| 0
 
−
| 0
 
−
| 0
 
−
| 0
 
−
|- class="even"
 
−
| Row6
 
−
| 0
 
−
| 0
 
−
| 0
 
−
| 0
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:16, 1 August 2018

ISBLANK (Value)


  • is the value to test.
    • ISBLANK(), returns TRUE if the value is blank.

Description

  • This function is one of the group in ISFUNCTIONS.
  • The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
  • ISBLANK function can be used to check for blank or null values.
  • This function will return the result as TRUE when given value or referred cell is empty otherwise the result is FALSE when the cell is nonempty.
  • The argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

Spreadsheet
A B C D
1 121 abc 12/1/2012
  1. =ISBLANK(A1)=FALSE
  2. =ISBLANK(B1)=FALSE
  3. =ISBLANK(C1)=FALSE
  4. =ISBLANK(D1)=TRUE

Related Videos

ISBLANK

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ISBLANK&oldid=210856"