Manuals/calci/ISTEXT

From ZCubes Wiki
Revision as of 20:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISTEXT'''(Value) where, '''Value''' -  represents the value in cell. </div> ---- <div id="1SpaceConte...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

ISTEXT(Value)

where,

Value -  represents the value in cell.


If cell having text, ISTEXT returns 1.


ISTEXT


Lets see an example in (Column1, Row2)

=ISTEXT(R1C1)

ISTEXT returns 0.

Cosider an another example

=ISTEXT(C2)

It returns 1.


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 5 smith 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