Difference between revisions of "Manuals/calci/ISNONTEXT"

From ZCubes Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''ISNONTEXT(n)'''</div><br/>
+
<div style="font-size:30px">'''ISNONTEXT (Value)'''</div><br/>
−
*<math>n</math> is the value to test.
+
*<math>Value</math> is any value to test.
−
 
+
**ISNONTEXT(), returns TRUE if the value is not text
  
 
==Description==
 
==Description==
−
*This function is  one of the group in <math>ISFUNCTIONS </math>.
+
*This function is  one of the group in [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]].
−
*The <math>IS FUNCTION </math> is also known as data information functions, data inspection functions or data-testing functions.
+
*The [[Manuals/calci/IS_FUNCTIONS| IS FUNCTIONS]] is also known as Data Information Functions, Data Inspection Functions or Data-Testing Functions.
−
* <math>ISNONTEXT(n) </math>, can be used to test whether the given values are not a text or text.  
+
* <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.  
 
*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 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.
+
*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.  
 
*When we giving any  argument with in double quotas, this function will consider as the text.  
−
*Also blank cells consider as the nontext.
+
*Also blank cells consider as the non-text.
  
 +
==Examples==
  
−
==Examples==
+
{| class="wikitable"
−
#74509
+
|+Spreadsheet
−
*=ISNONTEXT(B1) = TRUE
+
|-
−
#"65142"
+
! !! A !! B !! C
−
*=ISNONTEXT(B1) = Null
+
|-
−
#MONTHS   
+
! 1
−
*=ISNONTEXT(B1) = Null  
+
| 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==
 
==See Also==
Line 30: Line 44:
  
 
==References==
 
==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

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.

Examples

Spreadsheet
A B C
1 74509 "65142" MONTHS
2 "months"
  1. =ISNONTEXT(A1) = TRUE
  2. =ISNONTEXT(B1) = Null
  3. =ISNONTEXT(C1) = Null
  4. =ISNONTEXT(A2) = TRUE
  5. =ISNONTEXT(B2) = Null

Related Videos

ISNONTEXT

See Also

References

Is Function


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