ISTEXT

Returns the Boolean value “True” if the value passed to the function is text else returns “False”.

Syntax

= ISTEXT(value)

Parameters

Value

A value which has to be checked.  The value can be specified as a decimal value (e.g., 37.48), as a string (“123”), as a Date (“1/28/2010”), or as the value of a variable (e.g, ShippedDate).

Return Type

Boolean

Examples

Example

Returns

= ISTEXT(30)

False

= ISTEXT(“30”)

True

= ISTEXT(“abcd”)

True

= ISTEXT(ShippedDate)

False if the value of date is not of type text else returns True.