Manuals/calci/ISTEXT
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 |
