Calc ISTEXT function

Returns TRUE if value is text, or FALSE if value is anything else.

Help CentreFunctions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the ISTEXT function and is applicable to both the RPA and Cloud Automate's calculate functions.

Description

Returns TRUE if value is text, or FALSE if value is anything else.


Syntax

ISTEXT(value)

The ISTEXT function syntax has the following arguments:

  • value - Required. The value to test.

Example

FormulaDescriptionResult
=ISTEXT("text")Checks whether "text" is textTRUE
=ISTEXT(False)Checks whether False is textFALSE
=ISTEXT(-1)Checks whether -1 is textFALSE

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.