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

1. 74509

• =ISNONTEXT(B1) = TRUE

1. "65142"

• =ISNONTEXT(B1) = Null

1. MONTHS

• =ISNONTEXT(B1) = Null

See Also

• ISEVEN
• ISODD
• ISNUMBER
• ISTEXT