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 7: / Line 7: @@
 *These functions are simple data validation and data type checking functions.
 The ISFUNCTIONS are listed below:
- ISARRAY(n)
+*[[Manuals/calci/ISBLANK| ISBLANK(n)]]
- ISLEAPYEAR(n)
+**<math>n</math> refers to an empty cell.
- ISBLANK(n)
+*[[Manuals/calci/ISERR| ISERR(n)]]
- ISERR(n)
+**<math>n</math> refers to any error value except #N/A.
- ISERROR(n)
+*[[Manuals/calci/ISERROR| ISERROR(n)]]
- ISLOGICAL(n)
+**<math>n</math> refers to any error value
- ISNA(n)
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
- ISNONTEXT(n)
+**<math>n</math> refers to a logical value.
- ISREF(n)
+*[[Manuals/calci/ISNA| ISNA(n)]]
- ISTEXT(n)
+**<math>n</math> refers to the NaN error value.
- ISPMT(n)
+*[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]]
- ISEMPTY(n)
+**<math>n</math> refers to any item that is not text.
- ISNULL(n)
+*[[Manuals/calci/ISREF| ISREF(n)]]
- ISEVEN(n)
+**<math>n</math> refers to a reference.
- ISODD(n)
+*[[Manuals/calci/ISTEXT| ISTEXT(n)]]
- ISPRIME(n)
+**<math>n</math> refers to text.
-*where n is value to check with the  function.
+*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
-The n can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.
+**<math>n</math> refers to a number.
-*This function will give the result as either TRUE or FALSE according to the n value.
+*[[Manuals/calci/ISARRAY| ISARRAY(n)]]
-*This function will not convert any numbers from text.
+*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]
-*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/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)]]
+*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.
-.ISBLANK(n)
+==Examples==
-   n refers to an empty cell.
+#=ISEVEN(28) = TRUE
-.ISERR(n)
+#=ISODD(28) = FALSE
-   n refers to any error value except #N/A.
+#=ISNUMBER(A) = FALSE
-.ISERROR(n)
+#=ISBLANK(0) = FALSE
-   n refers to any error value
+#=ISERROR(3/0) = TRUE
-.ISLOGICAL(n)
+#=ISERR(2*6) = FALSE
-   n refers to a logical value.
+#=ISNONTEXT(121*56) = TRUE
-.ISNA(n)
-   n refers to the NaN error value.
+==Related Videos==
-.ISNONTEXT(n)
-   n refers to any item that is not text.
+{{#ev:youtube|V5aOdLfrXls|280|center|IS FUNCTIONS}}
-.ISNUMBER(n)
-   n refers to a number.
+==See Also==
-.ISREF(n)
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
-   n refers to a reference.
+*[[Manuals/calci/ISEVEN| ISEVEN(n)]]
-.ISTEXT(n)
+*[[Manuals/calci/ISODD| ISODD(n)]]
-   n refers to text.
+==Description==
+[http://en.wikipedia.org/wiki/Is_functions  Is Function]

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