Changes

Manuals/calci/IS FUNCTIONS (view source)

Revision as of 09:59, 11 December 2013

8,579 bytes removed , 09:59, 11 December 2013

no edit summary

Line 1: Line 1: −

<div style="font-size:30px">'''~~IS FUNCTIONS~~'''</div>

+

<div style="font-size:30px">'''ISFUNCTIONS(n)'''</div>

+

*<math>n</math> is the number

−

~~Syntax~~

+

==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:

+

ISARRAY(n)

+

ISLEAPYEAR(n)

+

ISBLANK(n)

+

ISERR(n)

+

ISERROR(n)

+

ISLOGICAL(n)

+

ISNA(n)

+

ISNONTEXT(n)

+

ISREF(n)

+

ISTEXT(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 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."

−

~~</div></div>~~

+

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.

−

~~----~~

−

~~<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">~~

−

~~Examples-~~1

+

*=ISLOGICAL(TRUE) is 1

+

*=ISLOGICAL(“TRUE”) is 0*

+

*=ISNUMBER(4) is 1

−

~~</div></div>~~

−

~~----~~

−

~~<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">''''''''''''''' ''' ''''''''''''</div></div>~~

−

~~----~~

−

~~<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">~~

−

~~Description~~

+

'''ISBLANK'''

+

'''V'''

+

'''ISERR'''

+

'''V'''

+

'''ISERROR'''

+

'''V'''

+

'''ISLOGICAL'''

+

'''ISNA'''

+

'''ISNONTEXT'''

+

'''ISNUMBER'''

+

'''ISREF'''

+

'''ISTEXT'''

−

~~</div></div>~~

+

*ISBLANK

−

~~----~~

+

V refers to an empty cell.

−

<div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> 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.</div></div>

+

*ISERR

−

~~----~~

+

Vl refers to any error value except #N/A.

−

~~<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">IS FUNCTIONS</div></div>~~

+

*ISERROR

−

~~----~~

+

V refers to any error value

−

~~<div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">~~

+

*ISLOGICAL

−

+

V refers to a logical value.

−

~~<nowiki>=ISLOGICAL(TRUE) is 1</nowiki>~~

+

*ISNA

−

+

V refers to the NaN error value.

−

~~<nowiki>=ISLOGICAL(“TRUE”) is 0</nowiki>~~

+

*ISNONTEXT

−

+

V refers to any item that is not text.

−

~~<nowiki>=ISNUMBER(4) is 1</nowiki>~~

+

*ISNUMBER

−

+

V refers to a number.

−

~~</div></div>~~

+

*ISREF

−

~~----~~

+

V refers to a reference.

−

~~<div id="12SpaceContent" class="zcontent" align="left">~~

+

*ISTEXT

−

+

V refers to text.

−

~~{| 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"> '''~~ISBLANK'''('''V''') '''ISERR'''('''V''') '''ISERROR'''('''V''') '''ISLOGICAL'''('''V''') '''ISNA'''('''V''') '''ISNONTEXT'''('''V''') '''ISNUMBER'''('''V''') '''ISREF'''('''V''') '''ISTEXT'''('''V''')

−

'''where V''' is the value that is to bet tested.

−

~~ ~~

−

~~{| width="587" cellpadding="1"~~

−

~~|- valign="bottom"~~

−

~~| width="78" bgcolor="#ffffff" |~~

−

~~<center>'''Function'''</center>~~

−

~~| width="505" bgcolor="#ffffff" |~~

−

~~<center>'''Shows 1 if '''</center>~~

−

|-

−

~~| width="78" valign="top" |~~

−

~~ ~~

−

~~| width="505" |~~

−

~~ ~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~ISBLANK~~

−

~~| width="505" |~~

−

~~~~V refers to an empty cell.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISERR~~~~

−

~~| width="505" |~~

−

~~~~Vl refers to any error value except #N/A.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISERROR~~~~

−

~~| width="505" |~~

−

~~~~V refers to any error value ~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISLOGICAL~~~~

−

~~| width="505" |~~

−

~~~~V refers to a logical value.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISNA~~~~

−

~~| width="505" |~~

−

~~~~V refers to the NaN error value.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISNONTEXT~~~~

−

~~| width="505" |~~

−

~~~~V refers to any item that is not text. ~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISNUMBER~~~~

−

~~| width="505" |~~

−

~~~~V refers to a number.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISREF~~~~

−

~~| width="505" |~~

−

~~~~V refers to a reference.~~~~

−

~~|- valign="top"~~

−

~~| width="78" |~~

−

~~~~ISTEXT~~~~

−

~~| width="505" |~~

−

~~~~V refers to text.

−

|}

−

~~ ~~

−

~~</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">~~

−

~~Let's see another example in Column1Row1~~

−

~~Let C1R1 = Welcome~~

−

~~<nowiki>=ISBLANK(C1R1) is 0</nowiki>~~

−

~~Let C3R1 = sav123~~

−

~~<nowiki>=ISTEXT(C3R1) is 1</nowiki>~~

−

~~///rly C1R2 = NaN~~

−

~~<nowiki>=ISERR(C1R2) is 0</nowiki>~~

−

~~</div>~~

−

~~----~~

Abin

writer

5,435

edits

Changes

Manuals/calci/IS FUNCTIONS (view source)

Revision as of 09:59, 11 December 2013

Navigation menu

Search