Difference between revisions of "Manuals/calci/ISNONTEXT"
Jump to navigation
Jump to search
(Created page with "==ISNONTEXT==") |
|||
Line 1: | Line 1: | ||
− | ==ISNONTEXT== | + | <div style="font-size:30px">'''ISNONTEXT(n)'''</div><br/> |
+ | *<math>n</math> is the value to test. | ||
+ | |||
+ | |||
+ | ==Description== | ||
+ | *This function is one of the group in <math>ISFUNCTIONS </math>. | ||
+ | *The <math>IS FUNCTION </math> is also known as data information functions, data inspection functions or data-testing functions. | ||
+ | * <math>ISNONTEXT(n) </math>, 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== | ||
+ | #74509 | ||
+ | *=ISNONTEXT(B1) = TRUE | ||
+ | #"65142" | ||
+ | *=ISNONTEXT(B1) = Null | ||
+ | #MONTHS | ||
+ | *=ISNONTEXT(B1) = Null | ||
+ | |||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
+ | *[[Manuals/calci/ISODD | ISODD ]] | ||
+ | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
+ | *[[Manuals/calci/ISTEXT |ISTEXT ]] | ||
+ | |||
+ | |||
+ | ==References== |
Revision as of 03:25, 10 January 2014
ISNONTEXT(n)
- is the value to test.
Description
- This function is one of the group in .
- The is also known as data information functions, data inspection functions or data-testing functions.
- , 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
- 74509
- =ISNONTEXT(B1) = TRUE
- "65142"
- =ISNONTEXT(B1) = Null
- MONTHS
- =ISNONTEXT(B1) = Null
See Also
* ISEVEN