Difference between revisions of "Manuals/calci/ISNONTEXT"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "==ISNONTEXT==")
 
Line 1: Line 1:
==ISNONTEXT==
+
<div style="font-size:30px">'''ISNONTEXT(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>ISNONTEXT(n) </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.
 +
*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==
 +
#74509
 +
*=ISNONTEXT(B1) = TRUE
 +
#"65142"
 +
*=ISNONTEXT(B1) = Null
 +
#MONTHS   
 +
*=ISNONTEXT(B1) = Null
 +
 
 +
 
 +
==See Also==
 +
*[[Manuals/calci/ISEVEN  | ISEVEN ]]
 +
*[[Manuals/calci/ISODD  | ISODD ]]
 +
*[[Manuals/calci/ISNUMBER  | ISNUMBER ]]
 +
*[[Manuals/calci/ISTEXT  |ISTEXT ]]
 +
 
 +
 
 +
==References==

Revision as of 04:25, 10 January 2014

ISNONTEXT(n)


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

  1. 74509
  • =ISNONTEXT(B1) = TRUE
  1. "65142"
  • =ISNONTEXT(B1) = Null
  1. MONTHS
  • =ISNONTEXT(B1) = Null


See Also

* ISEVEN  


References