Difference between revisions of "Manuals/calci/ISTEXT"

From ZCubes Wiki
Jump to navigation Jump to search
 
(11 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''ISTEXT(n)'''</div><br/>
+
<div style="font-size:30px">'''ISTEXT (Value) '''</div><br/>
−
*<math>n</math> is the value to test.
+
*<math>Value</math> is any value to test.
 +
**ISTEXT(), returns TRUE if the value is text.
  
 +
==Description==
 +
*This function is  one of the group in [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]].
 +
*The [[Manuals/calci/IS_FUNCTIONS| IS FUNCTION]] is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions.
 +
*<math>ISTEXT(Value)</math>, 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 <math>Value</math>  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.
 +
 +
==Examples==
 +
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C
 +
|-
 +
! 1
 +
| summer || 18764 ||"18764" 
 +
|-
 +
! 2
 +
|  || "she is good" ||
  
−
==Description==
+
|}
−
*This function is  one of the group in <math>ISFUNCTIONS</math>.
+
# =ISTEXT(A1) = TRUE
−
*The <math>IS FUNCTION</math>  is also known as data information functions, data inspection functions or data-testing functions.
+
# =ISTEXT(B1) = FALSE
−
*<math>ISTEXT(n)</math>,  can be used to test whether  the given values are text or not.
+
# =ISTEXT(C1) = TRUE
−
*This function gives the result as only TRUE or FALSE.
+
# =ISTEXT(A2) = FALSE
−
*The result is TRUE when the n value is text  otherwise the result is FALSE.
+
# =ISTEXT(B2) = TRUE
−
*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.
 
  
 +
==Related Videos==
  
−
==Examples==
+
{{#ev:youtube|dQp2Msi9Dlw|280|center|ISTEXT}}
−
#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==
 
==See Also==
Line 27: Line 40:
 
*[[Manuals/calci/ISODD  | ISODD ]]  
 
*[[Manuals/calci/ISODD  | ISODD ]]  
 
*[[Manuals/calci/ISNUMBER  | ISNUMBER ]]  
 
*[[Manuals/calci/ISNUMBER  | ISNUMBER ]]  
−
*[[Manuals/calci/ISNONTEXT  |ISNONTEXT ]]  
+
*[[Manuals/calci/ISNONTEXT  |ISNONTEXT ]]
  
 +
==References==
 +
*[http://en.wikipedia.org/wiki/Is_functions  Is Function]
  
−
==References==
+
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14:30, 2 August 2018

ISTEXT (Value)


  • is any value to test.
    • ISTEXT(), returns TRUE if the value is text.

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 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.

Examples

Spreadsheet
A B C
1 summer 18764 "18764"
2 "she is good"
  1. =ISTEXT(A1) = TRUE
  2. =ISTEXT(B1) = FALSE
  3. =ISTEXT(C1) = TRUE
  4. =ISTEXT(A2) = FALSE
  5. =ISTEXT(B2) = TRUE

Related Videos

ISTEXT

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ISTEXT&oldid=210866"