Difference between revisions of "Manuals/calci/IS FUNCTIONS"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
*These functions are simple data validation and data type checking functions. | *These functions are simple data validation and data type checking functions. | ||
The ISFUNCTIONS are listed below: | The ISFUNCTIONS are listed below: | ||
| − | + | *[[Manuals/calci/ISARRAY| ISARRAY(n)]] | |
| − | + | *[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] | |
| − | + | *[[Manuals/calci/ISBLANK| ISBLANK(n)]] | |
| − | + | *[[Manuals/calci/ISERR| ISERR(n)]] | |
| − | + | *[[Manuals/calci/ISERROR| ISERROR(n)]] | |
| − | + | *[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]] | |
| − | + | *[[Manuals/calci/ISNA| ISNA(n)]] | |
| − | + | *[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]] | |
| − | + | *[[Manuals/calci/ISREF| ISREF(n)]] | |
| − | + | *[[Manuals/calci/ISTEXT| ISTEXT(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)]] | |
| + | |||
| + | |||
*where n is value to check with the function. | *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. | The n can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these. | ||
Revision as of 05:52, 11 December 2013
ISFUNCTIONS(n)
- is the number
is the numberDescription
- 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:
- 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 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.
1.ISBLANK(n) n refers to an empty cell. 2.ISERR(n) n refers to any error value except #N/A. 3.ISERROR(n) n refers to any error value 4.ISLOGICAL(n) n refers to a logical value. 5.ISNA(n) n refers to the NaN error value. 6.ISNONTEXT(n) n refers to any item that is not text. 7.ISNUMBER(n) n refers to a number. 8.ISREF(n) n refers to a reference. 9.ISTEXT(n) n refers to text.