Difference between revisions of "Manuals/calci/IS FUNCTIONS"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
| − | + | 1.ISBLANK | |
| − | V refers to an empty cell. | + | V refers to an empty cell. |
| − | + | 2.ISERR | |
| − | + | V refers to any error value except #N/A. | |
| − | + | 3.ISERROR | |
V refers to any error value | V refers to any error value | ||
| − | + | 4.ISLOGICAL | |
V refers to a logical value. | V refers to a logical value. | ||
| − | + | 5.ISNA | |
V refers to the NaN error value. | V refers to the NaN error value. | ||
| − | + | 6.ISNONTEXT | |
V refers to any item that is not text. | V refers to any item that is not text. | ||
| − | + | 7.ISNUMBER | |
V refers to a number. | V refers to a number. | ||
| − | + | 8.ISREF | |
V refers to a reference. | V refers to a reference. | ||
| − | + | 9.ISTEXT | |
V refers to text.</font></font> | V refers to text.</font></font> | ||
Revision as of 04:40, 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 V refers to an empty cell. 2.ISERR V refers to any error value except #N/A. 3.ISERROR V refers to any error value 4.ISLOGICAL V refers to a logical value. 5.ISNA V refers to the NaN error value. 6.ISNONTEXT V refers to any item that is not text. 7.ISNUMBER V refers to a number. 8.ISREF V refers to a reference. 9.ISTEXT V refers to text.