Difference between revisions of "Manuals/calci/ISNONTEXT"

Latest revision as of 17:23, 1 August 2018

ISNONTEXT (Value)

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.
$ISNONTEXT(Value)$ , 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.

Spreadsheet
	A	B	C
1	74509	"65142"	MONTHS
2		"months"

@@ 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==
 *This function is  one of the group in [[Manuals/calci/IS_FUNCTIONS| IS 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.
 *The result is TRUE when the n value is  non-text  otherwise the result is FALSE.