ISTEXT

Returns TRUE if the value is a text, FALSE otherwise

Usage

ISTEXT(value)

Parameters

value

(Required) The value to check

Examples

Example With these variables Result

ISTEXT(123)

(None)

FALSE

ISTEXT(val)

val is -12.3

FALSE

ISTEXT(val)

val is "-12.3"

TRUE

ISTEXT(val)

val is "Canada"

TRUE

ISTEXT(val)

val is DATE(2021, 2, 3)

FALSE

See also