Manuals/calci/ISTEXT

ISTEXT(n)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the value to test.

Description

• This function is one of the group in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISFUNCTIONS} .
• The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IS FUNCTION} is also known as data information functions, data inspection functions or data-testing functions.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISTEXT(n)} , can be used to test whether the given values are text or not.
• This function gives the result as only 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 quotas, 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

• ISEVEN
• ISODD
• ISNUMBER
• ISNONTEXT