Difference between revisions of "Manuals/calci/IS FUNCTIONS"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] | *[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] | ||
*[[Manuals/calci/ISBLANK| ISBLANK(n)]] | *[[Manuals/calci/ISBLANK| ISBLANK(n)]] | ||
| + | **n refers to an empty cell. | ||
*[[Manuals/calci/ISERR| ISERR(n)]] | *[[Manuals/calci/ISERR| ISERR(n)]] | ||
| + | **n refers to any error value except #N/A. | ||
*[[Manuals/calci/ISERROR| ISERROR(n)]] | *[[Manuals/calci/ISERROR| ISERROR(n)]] | ||
| + | **n refers to any error value | ||
*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]] | *[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]] | ||
| + | **n refers to a logical value. | ||
*[[Manuals/calci/ISNA| ISNA(n)]] | *[[Manuals/calci/ISNA| ISNA(n)]] | ||
| + | **n refers to the NaN error value. | ||
*[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]] | *[[Manuals/calci/ISNONTEXT| ISNONTEXT(n)]] | ||
| + | **n refers to any item that is not text. | ||
*[[Manuals/calci/ISREF| ISREF(n)]] | *[[Manuals/calci/ISREF| ISREF(n)]] | ||
| + | **n refers to a reference. | ||
*[[Manuals/calci/ISTEXT| ISTEXT(n)]] | *[[Manuals/calci/ISTEXT| ISTEXT(n)]] | ||
| + | **n refers to text. | ||
*[[Manuals/calci/ISPMT| ISPMT(n)]] | *[[Manuals/calci/ISPMT| ISPMT(n)]] | ||
*[[Manuals/calci/ISEMPTY| ISEMPTY(n)]] | *[[Manuals/calci/ISEMPTY| ISEMPTY(n)]] | ||
| Line 24: | Line 32: | ||
*[[Manuals/calci/ISPRIME| ISPRIME(n)]] | *[[Manuals/calci/ISPRIME| ISPRIME(n)]] | ||
| − | + | *where <math>n</math> is value to check with the function. | |
| − | *where n 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. |
| − | 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 <math>n</math> value. |
| − | *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. | *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. | *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. | ||
Revision as of 05:04, 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)
- 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.
- ISPMT(n)
- ISEMPTY(n)
- ISNULL(n)
- ISEVEN(n)
- ISODD(n)
- ISPRIME(n)
- where is value to check with the function.
The 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 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.