Difference between revisions of "Manuals/calci/IS FUNCTIONS"
Jump to navigation
Jump to search
| (8 intermediate revisions by one other user not shown) | |||
| Line 24: | Line 24: | ||
**<math>n</math> refers to text. | **<math>n</math> refers to text. | ||
*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]] | *[[Manuals/calci/ISNUMBER| ISNUMBER(n)]] | ||
| − | ** | + | **<math>n</math> refers to a number. |
*[[Manuals/calci/ISARRAY| ISARRAY(n)]] | *[[Manuals/calci/ISARRAY| ISARRAY(n)]] | ||
*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] | *[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] | ||
| Line 37: | Line 37: | ||
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 <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. | ||
*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 <math>n</math> value. | ||
| − | *This function will not convert | + | *This function will not convert to numbers from text. |
| − | * | + | *Function will consider as string if its written in quotes(""). |
| + | *"20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string. | ||
| + | |||
| + | ==Examples== | ||
| + | #=ISEVEN(28) = TRUE | ||
| + | #=ISODD(28) = FALSE | ||
| + | #=ISNUMBER(A) = FALSE | ||
| + | #=ISBLANK(0) = FALSE | ||
| + | #=ISERROR(3/0) = TRUE | ||
| + | #=ISERR(2*6) = FALSE | ||
| + | #=ISNONTEXT(121*56) = TRUE | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|V5aOdLfrXls|280|center|IS FUNCTIONS}} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]] | ||
| + | *[[Manuals/calci/ISEVEN| ISEVEN(n)]] | ||
| + | *[[Manuals/calci/ISODD| ISODD(n)]] | ||
| + | |||
| + | ==Description== | ||
| + | [http://en.wikipedia.org/wiki/Is_functions Is Function] | ||
Latest revision as of 13:47, 12 June 2015
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:
- ISBLANK(n)
- refers to an empty cell.
- ISERR(n)
- refers to any error value except #N/A.
- ISERROR(n)
- refers to any error value
- ISLOGICAL(n)
- refers to a logical value.
- ISNA(n)
- refers to the NaN error value.
- ISNONTEXT(n)
- refers to any item that is not text.
- ISREF(n)
- refers to a reference.
- ISTEXT(n)
- refers to text.
- ISNUMBER(n)
- refers to a number.
- ISARRAY(n)
- ISLEAPYEAR(n)
- 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 to numbers from text.
- Function will consider as string if its written in quotes("").
- "20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string.
Examples
- =ISEVEN(28) = TRUE
- =ISODD(28) = FALSE
- =ISNUMBER(A) = FALSE
- =ISBLANK(0) = FALSE
- =ISERROR(3/0) = TRUE
- =ISERR(2*6) = FALSE
- =ISNONTEXT(121*56) = TRUE