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

Latest revision as of 14: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

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

Latest revision as of 14:47, 12 June 2015

Contents

Description

Examples

Related Videos

See Also

Description

Navigation menu

Search

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IS FUNCTIONS'''</div><br/>
+<div style="font-size:30px">'''ISFUNCTIONS(n)'''</div><br/>
+*<math>n</math> is the number
-Syntax
+==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:
+*[[Manuals/calci/ISBLANK| ISBLANK(n)]]
+**<math>n</math> refers to an empty cell.
+*[[Manuals/calci/ISERR| ISERR(n)]]
+**<math>n</math> refers to any error value except #N/A.
+*[[Manuals/calci/ISERROR| ISERROR(n)]]
+**<math>n</math> refers to any error value
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
+**<math>n</math> refers to a logical value.
+*[[Manuals/calci/ISNA| ISNA(n)]]
+**<math>n</math> refers to the NaN error value.
+*[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]]
+**<math>n</math> refers to any item that is not text.
+*[[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)]]
-</div></div>
+*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.
-<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
+*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.
-Examples-1
+==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
-</div></div>
+==Related Videos==
-----
-<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
-----
-<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
-<font size="5">Description</font>
+{{#ev:youtube|V5aOdLfrXls|280|center|IS FUNCTIONS}}
-</div></div>
+==See Also==
-----
+*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
-<div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">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.</font></font></font></div></div>
+*[[Manuals/calci/ISEVEN| ISEVEN(n)]]
-----
+*[[Manuals/calci/ISODD| ISODD(n)]]
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">IS FUNCTIONS</font></div></div>
-----
-<div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISLOGICAL(TRUE) is 1</nowiki></font></font></font>
+==Description==
+[http://en.wikipedia.org/wiki/Is_functions  Is Function]
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISLOGICAL(“TRUE”) is 0</nowiki></font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISNUMBER(4) is 1</nowiki></font></font></font>
-</div></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left">
-{| id="TABLE1" class="SpreadSheet blue"
-|- class="even"
-| class=" " |
-| Column1
-| Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f" | 1
-| class="SelectTD                 sshl_f sshl_t ChangeBGColor" |
-| class=" sshl_t" |
-| class=" sshl_t" |
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | 0
-| class="f52543                 sshl_t" |
-| class=" sshl_t" |
-| class=" sshl_t" |
-|- class="odd"
-| Row3
-| class="sshl_f" | 1
-| class=" sshl_t" |
-| class=" sshl_t" |
-| class=" sshl_t" |
-|- class="even"
-| Row4
-| class="                                                                                             " |
-|
-|
-|
-|- class="odd"
-| class=" " | Row5
-|
-|
-|
-|
-|- class="even"
-| Row6
-|
-|
-|
-|
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
-<div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISBLANK'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISERR'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISERROR'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISLOGICAL'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISNA'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISNONTEXT'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISNUMBER'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISREF'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)<br /></font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISTEXT'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">   is the value that is to bet tested. </font></font></font>
-<br /><br />
-{| width="587" cellpadding="1"
-|- valign="bottom"
-| width="78" bgcolor="#ffffff" |
-<center><font color="#000000"><font face="Tahoma, sans-serif"><font size="1">'''Function'''</font></font></font></center>
-| width="505" bgcolor="#ffffff" |
-<center><font color="#000000"><font face="Tahoma, sans-serif"><font size="1">'''Shows 1 if '''</font></font></font></center>
-|-
-| width="78" valign="top" |
-<br />
-| width="505" |
-<br />
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISBLANK</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to an empty cell.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISERR</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">Vl refers to any error value except #N/A.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISERROR</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to any error value </font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISLOGICAL</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to a logical value.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISNA</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to the NaN error value.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISNONTEXT</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to any item that is not text. </font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISNUMBER</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to a number.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISREF</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to a reference.</font></font>
-|- valign="top"
-| width="78" |
-<font face="Tahoma, sans-serif"><font size="1">ISTEXT</font></font>
-| width="505" |
-<font face="Tahoma, sans-serif"><font size="1">V refers to text.</font></font>
-|}
-<br />
-</div></div>
-----
-<div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
-Examples-2
-</div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left">
-{| id="TABLE3" class="SpreadSheet blue"
-|- class="even"
-| class="               " |
-<div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| Column1
-| Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f " | Welcome
-| class="sshl_f" | 0
-| class="sshl_f" | sav123
-| class="sshl_f" | 1
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | NaN
-| class="sshl_f" | 0
-| class="                                               sshl_f  " |
-|
-|- class="odd"
-| Row3
-| class="                                                                                                               sshl_f  " |
-|
-|
-|
-|- class="even"
-| Row4
-|
-| class="SelectTD  SelectTD" |
-|
-|
-|- class="odd"
-| class=" " | Row5
-|
-|
-|
-|
-|- class="even"
-| Row6
-|
-|
-|
-|
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
-<div id="7SpaceContent" class="zcontent" align="left">
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see another example in Column1Row1</font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let C1R1 = Welcome</font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISBLANK(C1R1) is 0</nowiki></font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let C3R1 = sav123</font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISTEXT(C3R1) is 1</nowiki></font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">///rly C1R2 = NaN</font></font></font>
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISERR(C1R2) is 0</nowiki></font></font></font>
-</div>
-----