Manuals/calci/ISBLANK

Revision as of 20:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISBLANK'''(Value) where, '''Value''' -  represents the cell. </div> ---- <div id="1SpaceContent" clas...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

ISBLANK(Value)

where,

Value -  represents the cell.


If cell is empty, ISBLANK returns 1.


ISBLANK


Lets see an example in (Column1, Row2)

=ISBLANK(R1C1)

ISBLANK returns 0.

Cosider an another example

=ISBLANK(C2)

It returns 1.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 5 0 0 0
Row2 0 1 0 0
Row3 0
0 0
Row4 0 0 0 0
Row5 0 0 0 0
Row6 0 0 0 0