Difference between revisions of "Manuals/calci/ISTEXT"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISTEXT'''(Value) where, '''Value''' - represents the value in cell. </div> ---- <div id="1SpaceConte...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ISTEXT(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>ISTEXT(n)</math>, can be used to test whether the given values are text or not. | ||
| + | *This function gives the result as only TRUE or FALSE. | ||
| + | *The result is TRUE when the n 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 quotas, this function will consider as the text. | ||
| − | |||
| − | + | ==Examples== | |
| − | + | #summer | |
| − | + | =ISTEXT(B1)=TRUE | |
| − | + | #18764 | |
| − | + | =ISTEXT(B1)=FALSE | |
| + | #"18764" | ||
| + | =ISTEXT(B1)=TRUE | ||
| + | =ISTEXT(C1)=FALSE(in c1 give blank space) | ||
| + | #"She is good" | ||
| + | =ISTEXT(B1)=TRUE | ||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/ISEVEN | ISEVEN ]] | |
| − | + | *[[Manuals/calci/ISODD | ISODD ]] | |
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| + | *[[Manuals/calci/ISNONTEXT |ISNONTEXT ]] | ||
| − | |||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:20, 10 January 2014
ISTEXT(n)
- is the value to test.
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 text or not.
- This function gives the result as only TRUE or FALSE.
- The result is TRUE when the n 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 quotas, this function will consider as the text.
.
is also known as data information functions, data inspection functions or data-testing functions.
, can be used to test whether the given values are text or not.
Examples
- summer
=ISTEXT(B1)=TRUE
- 18764
=ISTEXT(B1)=FALSE
- "18764"
=ISTEXT(B1)=TRUE =ISTEXT(C1)=FALSE(in c1 give blank space)
- "She is good"
=ISTEXT(B1)=TRUE
See Also