Manuals/calci/ISNONTEXT

ISNONTEXT(n)

• $n$ is the value to test.

Description

• This function is one of the group in $ISFUNCTIONS$.
• The $ISFUNCTION$ is also known as data information functions, data inspection functions or data-testing functions.
• $ISNONTEXT(n)$, can be used to test whether the given values are not a text or text.
• This function gives the result as only TRUE or FALSE.
• The result is TRUE when the n value is nontext 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.
• Also blank cells consider as the nontext.

Examples

Spreadsheet

	A	B	C
1	74509	"65142"	MONTHS
2		"months"

1. =ISNONTEXT(A1) = TRUE
2. =ISNONTEXT(B1) = Null
3. =ISNONTEXT(C1) = Null
4. =ISNONTEXT(A2) = TRUE
5. =ISNONTEXT(B2) = Null

See Also

• ISEVEN
• ISODD
• ISNUMBER
• ISTEXT