Difference between revisions of "Manuals/calci/IS FUNCTIONS"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
==Description== | ==Description== | ||
| − | + | *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) | + | 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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
'''ISBLANK''' | '''ISBLANK''' | ||
Revision as of 04:15, 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.
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.
ISBLANK V ISERR V ISERROR V ISLOGICAL ISNA ISNONTEXT ISNUMBER ISREF ISTEXT
- ISBLANK
V refers to an empty cell.
- ISERR
Vl refers to any error value except #N/A.
- ISERROR
V refers to any error value
- ISLOGICAL
V refers to a logical value.
- ISNA
V refers to the NaN error value.
- ISNONTEXT
V refers to any item that is not text.
- ISNUMBER
V refers to a number.
- ISREF
V refers to a reference.
- ISTEXT
V refers to text.