Difference between revisions of "Manuals/calci/IS FUNCTIONS"

Latest revision as of 13:47, 12 June 2015

ISFUNCTIONS(n)

$n$ is the number

Description

This function is a group of Information Functions that can be used to find out information about a specific.
The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
These functions are simple data validation and data type checking functions.

The ISFUNCTIONS are listed below:

ISBLANK(n)
- $n$ refers to an empty cell.
ISERR(n)
- $n$ refers to any error value except #N/A.
ISERROR(n)
- $n$ refers to any error value
ISLOGICAL(n)
- $n$ refers to a logical value.
ISNA(n)
- $n$ refers to the NaN error value.
ISNONTEXT(n)
- $n$ refers to any item that is not text.
ISREF(n)
- $n$ refers to a reference.
ISTEXT(n)
- $n$ refers to text.
ISNUMBER(n)
- $n$ refers to a number.
ISARRAY(n)
ISLEAPYEAR(n)
ISPMT(n)
ISEMPTY(n)
ISNULL(n)
ISEVEN(n)
ISODD(n)
ISPRIME(n)

where $n$ is value to check with the function.

The $n$ can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.

This function will give the result as either TRUE or FALSE according to the $n$ value.
This function will not convert to numbers from text.
Function will consider as string if its written in quotes("").
"20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string.

Examples

=ISEVEN(28) = TRUE
=ISODD(28) = FALSE
=ISNUMBER(A) = FALSE
=ISBLANK(0) = FALSE
=ISERROR(3/0) = TRUE
=ISERR(2*6) = FALSE
=ISNONTEXT(121*56) = TRUE

Description

Is Function

@@ Line 3: / Line 3: @@
 ==Description==
-"This function isa group of Information Functions that can be used to find out information about a specific.The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.These functions are simple data validation and data type checking functions.The IS FUNCTIONS are listed below:
+*This function is a group of Information Functions that can be used to find out information about a specific.
-ISARRAY(n)
+*The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
-ISLEAPYEAR(n)
+*These functions are simple data validation and data type checking functions.
-ISBLANK(n)
+The ISFUNCTIONS are listed below:
-ISERR(n)
+*[[Manuals/calci/ISBLANK| ISBLANK(n)]]
-ISERROR(n)
+**<math>n</math> refers to an empty cell.
-ISLOGICAL(n)
+*[[Manuals/calci/ISERR| ISERR(n)]]
-ISNA(n)
+**<math>n</math> refers to any error value except #N/A.
-ISNONTEXT(n)
+*[[Manuals/calci/ISERROR| ISERROR(n)]]
-ISREF(n)
+**<math>n</math> refers to any error value
-ISTEXT(n)
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
-ISPMT(n)
+**<math>n</math> refers to a logical value.
-ISEMPTY(n)
+*[[Manuals/calci/ISNA| ISNA(n)]]
-ISNULL(n)
+**<math>n</math> refers to the NaN error value.
-ISEVEN(n)
+*[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]]
-ISODD(n)
+**<math>n</math> refers to any item that is not text.
-ISPRIME(n), where n is value to check with the  function.The n can be any type like emptycell, boolean values,text,nontext,number,referencevalue or name referring to any of these.this function will give the result as either TRUE or FALSE according to the n value. This function will not convert any numbers from  text. For e.g. ""20"" is normally converted as a number 20. But in ISNUMBER(""20"") will return FALSE, because ""20"" will not convert in to number."
+*[[Manuals/calci/ISREF| ISREF(n)]]
+**<math>n</math> refers to a reference.
+*[[Manuals/calci/ISTEXT| ISTEXT(n)]]
+**<math>n</math> refers to text.
+*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
+**<math>n</math> refers to a number.
+*[[Manuals/calci/ISARRAY| ISARRAY(n)]]
+*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]
+*[[Manuals/calci/ISPMT| ISPMT(n)]]
+*[[Manuals/calci/ISEMPTY| ISEMPTY(n)]]
+*[[Manuals/calci/ISNULL| ISNULL(n)]]
+*[[Manuals/calci/ISEVEN| ISEVEN(n)]]
+*[[Manuals/calci/ISODD| ISODD(n)]]
+*[[Manuals/calci/ISPRIME| ISPRIME(n)]]
-These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
+*where <math>n</math> is value to check with the  function.
+The <math>n</math> can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.
+*This function will give the result as either TRUE or FALSE according to the <math>n</math> value.
+*This function will not convert to numbers from text.
+*Function will consider as string if its written in quotes("").
+*"20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string.
-*=ISLOGICAL(TRUE) is 1
+==Examples==
-*=ISLOGICAL(“TRUE”) is 0*
+#=ISEVEN(28) = TRUE
-*=ISNUMBER(4) is 1
+#=ISODD(28) = FALSE
+#=ISNUMBER(A) = FALSE
+#=ISBLANK(0) = FALSE
+#=ISERROR(3/0) = TRUE
+#=ISERR(2*6) = FALSE
+#=ISNONTEXT(121*56) = TRUE
+==Related Videos==
-'''ISBLANK'''
+{{#ev:youtube|V5aOdLfrXls|280|center|IS FUNCTIONS}}
-'''V'''
-'''ISERR'''
-'''V'''
-'''ISERROR'''
-'''V'''
-'''ISLOGICAL'''
-'''ISNA'''
-'''ISNONTEXT'''
-'''ISNUMBER'''
-'''ISREF'''
-'''ISTEXT'''
-*ISBLANK
+==See Also==
-V refers to an empty cell.
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
-*ISERR
+*[[Manuals/calci/ISEVEN| ISEVEN(n)]]
- Vl refers to any error value except #N/A.
+*[[Manuals/calci/ISODD| ISODD(n)]]
-*ISERROR
- V refers to any error value
+==Description==
-*ISLOGICAL
+[http://en.wikipedia.org/wiki/Is_functions  Is Function]
- V refers to a logical value.
-*ISNA
- V refers to the NaN error value.
-*ISNONTEXT
- V refers to any item that is not text.
-*ISNUMBER
- V refers to a number.
-*ISREF
- V refers to a reference.
-*ISTEXT
- V refers to text.</font></font>

Difference between revisions of "Manuals/calci/IS FUNCTIONS"

Latest revision as of 13:47, 12 June 2015

Contents

Description

Examples

Related Videos

See Also

Description

Navigation menu

Search