Difference between revisions of "Manuals/calci/ISNONTEXT"
Jump to navigation
Jump to search
(Created page with "==ISNONTEXT==") |
|||
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | ==ISNONTEXT== | + | <div style="font-size:30px">'''ISNONTEXT (Value)'''</div><br/> |
| + | *<math>Value</math> is any value to test. | ||
| + | **ISNONTEXT(), returns TRUE if the value is not text | ||
| + | |||
| + | ==Description== | ||
| + | *This function is one of the group in [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]]. | ||
| + | *The [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]] is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions. | ||
| + | * <math>ISNONTEXT(Value)</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 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. | ||
| + | |||
| + | ==Examples== | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |+Spreadsheet | ||
| + | |- | ||
| + | ! !! A !! B !! C | ||
| + | |- | ||
| + | ! 1 | ||
| + | | 74509 || "65142" ||MONTHS | ||
| + | |- | ||
| + | ! 2 | ||
| + | | || "months" || | ||
| + | |||
| + | |} | ||
| + | #=ISNONTEXT(A1) = TRUE | ||
| + | #=ISNONTEXT(B1) = Null | ||
| + | #=ISNONTEXT(C1) = Null | ||
| + | #=ISNONTEXT(A2) = TRUE | ||
| + | #=ISNONTEXT(B2) = Null | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|REAJStT8EfE|280|center|ISNONTEXT}} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
| + | *[[Manuals/calci/ISODD | ISODD ]] | ||
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| + | *[[Manuals/calci/ISTEXT |ISTEXT ]] | ||
| + | |||
| + | ==References== | ||
| + | [http://en.wikipedia.org/wiki/Is_functions Is Function] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 17:23, 1 August 2018
ISNONTEXT (Value)
- is any value to test.
- ISNONTEXT(), returns TRUE if the value is not text
is any 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
Related Videos
See Also
References