| Line 3: |
Line 3: |
| | | | |
| | ==Description== | | ==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) | + | ISARRAY(n) |
| − | ISERROR(n) | + | ISLEAPYEAR(n) |
| − | ISLOGICAL(n) | + | ISBLANK(n) |
| − | ISNA(n) | + | ISERR(n) |
| − | ISNONTEXT(n) | + | ISERROR(n) |
| − | ISREF(n) | + | ISLOGICAL(n) |
| − | ISTEXT(n) | + | ISNA(n) |
| − | ISPMT(n) | + | ISNONTEXT(n) |
| − | ISEMPTY(n) | + | ISREF(n) |
| − | ISNULL(n) | + | ISTEXT(n) |
| − | ISEVEN(n) | + | ISPMT(n) |
| − | ISODD(n) | + | ISEMPTY(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." | + | 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 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. |
| | | | |
| | 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. | | 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. |
| − |
| |
| − | *=ISLOGICAL(TRUE) is 1
| |
| − | *=ISLOGICAL(“TRUE”) is 0*
| |
| − | *=ISNUMBER(4) is 1
| |
| − |
| |
| | | | |
| | '''ISBLANK''' | | '''ISBLANK''' |