Difference between revisions of "Manuals/calci/ISNONTEXT"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
==Examples== | ==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 | ||
==See Also== | ==See Also== | ||
Revision as of 22:58, 14 January 2014
ISNONTEXT(n)
- is the value to test.
Description
- This function is one of the group in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISFUNCTIONS } .
- The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IS FUNCTION } is also known as data information functions, data inspection functions or data-testing functions.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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
| A | B | C | |
|---|---|---|---|
| 1 | 74509 | "65142" | MONTHS |
| 2 | "months" |
- =ISNONTEXT(A1) = TRUE
- =ISNONTEXT(B1) = Null
- =ISNONTEXT(C1) = Null
- =ISNONTEXT(A2) = TRUE
- =ISNONTEXT(B2) = Null