Difference between revisions of "Manuals/calci/ISTEXT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''ISTEXT(n)'''</div><br/> | <div style="font-size:30px">'''ISTEXT(n)'''</div><br/> | ||
*<math>n</math> is the value to test. | *<math>n</math> is the value to test. | ||
| − | |||
==Description== | ==Description== | ||
| − | *This function is one of the group in | + | *This function is one of the group in [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]]. |
| − | *The | + | *The [[Manuals/calci/IS_FUNCTIONS| IS FUNCTION]] is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions. |
| − | *<math>ISTEXT(n)</math>, | + | *<math>ISTEXT(n)</math>, can be used to test whether the given values is text or not. |
| − | *This function gives the result as | + | *This function gives the result only as TRUE or FALSE. |
| − | *The result is TRUE when the n value is text | + | *The result is TRUE when the <math>n</math> value is text otherwise the result is FALSE. |
| − | *The argument can be blank, or it can contain data such as text, numbers, error values, | + | *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 quotes, this function will consider as the text. | |
==Examples== | ==Examples== | ||
| Line 35: | Line 34: | ||
*[[Manuals/calci/ISNUMBER | ISNUMBER ]] | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
*[[Manuals/calci/ISNONTEXT |ISNONTEXT ]] | *[[Manuals/calci/ISNONTEXT |ISNONTEXT ]] | ||
| − | |||
==See Also== | ==See Also== | ||
==References== | ==References== | ||
Revision as of 22:52, 23 January 2014
ISTEXT(n)
- is the value to test.
is the value to test.Description
- This function is one of the group in IS FUNCTIONS.
- The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions.
- , can be used to test whether the given values is text or not.
- This function gives the result only as TRUE or FALSE.
- The result is TRUE when the value is 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 quotes, this function will consider as the text.
, can be used to test whether the given values is text or not.Examples
| A | B | C | |
|---|---|---|---|
| 1 | summer | 18764 | "18764" |
| 2 | "she is good" |
- =ISTEXT(A1) = TRUE
- =ISTEXT(B1) = FALSE
- =ISTEXT(C1) = TRUE
- =ISTEXT(A2) = FALSE
- =ISTEXT(B2) = TRUE