Manuals/calci/ISTEXT

ISTEXT(n)

• $n$ is the value to test.

Description

• This function is one of the group in IS FUNCTIONS.
• The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions.
• $ISTEXT(n)$, can be used to test whether the given values is text or not.
• This function gives the result only as TRUE or FALSE.
• The result is TRUE when the $n$ value is text otherwise the result is FALSE.
• The argument can be blank, or it can contain data such as text, numbers, error values, logical values or any equations.
• When we giving any argument with in double quotes, this function will consider as the text.

Examples

Spreadsheet

	A	B	C
1	summer	18764	"18764"
2		"she is good"

1. =ISTEXT(A1) = TRUE
2. =ISTEXT(B1) = FALSE
3. =ISTEXT(C1) = TRUE
4. =ISTEXT(A2) = FALSE
5. =ISTEXT(B2) = TRUE