Manuals/calci/ISTEXT

ISTEXT (Value)

• $Value$ is any value to test.
  • ISTEXT(), returns TRUE if the value is text.

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(Value)$, 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 $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

Related Videos

ISTEXT

See Also

• ISEVEN
• ISODD
• ISNUMBER
• ISNONTEXT

References

• Is Function

• List of Main Z Functions

• Z3 home