Difference between revisions of "Manuals/calci/ISNONTEXT"
Jump to navigation
Jump to search
| Line 31: | Line 31: | ||
#=ISNONTEXT(A2) = TRUE | #=ISNONTEXT(A2) = TRUE | ||
#=ISNONTEXT(B2) = Null | #=ISNONTEXT(B2) = Null | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|REAJStT8EfE|280|center|ISNONTEXT}} | ||
==See Also== | ==See Also== | ||
| Line 39: | Line 43: | ||
==References== | ==References== | ||
| + | [http://en.wikipedia.org/wiki/Is_functions Is Function] | ||
Revision as of 14:19, 26 June 2015
ISNONTEXT(n)
- is the value to test.
is the value to test.Description
- This function is one of the group in IS FUNCTIONS.
- The IS FUNCTIONS 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 non-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.
- Also blank cells consider as the non-text.
, can be used to test whether the given values are not a text or text.Examples
| A | B | C | |
|---|---|---|---|
| 1 | 74509 | "65142" | MONTHS |
| 2 | "months" |
- =ISNONTEXT(A1) = TRUE
- =ISNONTEXT(B1) = Null
- =ISNONTEXT(C1) = Null
- =ISNONTEXT(A2) = TRUE
- =ISNONTEXT(B2) = Null