|
|
(22 intermediate revisions by one other user not shown) |
Line 1: |
Line 1: |
− | <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | + | <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>
| |
− | ----
| |