writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 7:
Line 7: − *[[Manuals/calci/ISARRAY| ISARRAY(n)]] − *[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]] − + − + − + − + − + − + − + − + + +
Manuals/calci/IS FUNCTIONS (view source)
Revision as of 11:16, 11 December 2013
, 11:16, 11 December 2013→Description
*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/ISBLANK| ISBLANK(n)]]
*[[Manuals/calci/ISBLANK| ISBLANK(n)]]
**n refers to an empty cell.
**<math>n</math> refers to an empty cell.
*[[Manuals/calci/ISERR| ISERR(n)]]
*[[Manuals/calci/ISERR| ISERR(n)]]
**n refers to any error value except #N/A.
**<math>n</math> refers to any error value except #N/A.
*[[Manuals/calci/ISERROR| ISERROR(n)]]
*[[Manuals/calci/ISERROR| ISERROR(n)]]
**n refers to any error value
**<math>n</math> refers to any error value
*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
**n refers to a logical value.
**<math>n</math> refers to a logical value.
*[[Manuals/calci/ISNA| ISNA(n)]]
*[[Manuals/calci/ISNA| ISNA(n)]]
**n refers to the NaN error value.
**<math>n</math>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.
**<math>n</math> refers to any item that is not text.
*[[Manuals/calci/ISREF| ISREF(n)]]
*[[Manuals/calci/ISREF| ISREF(n)]]
**n refers to a reference.
**<math>n</math> refers to a reference.
*[[Manuals/calci/ISTEXT| ISTEXT(n)]]
*[[Manuals/calci/ISTEXT| ISTEXT(n)]]
**n refers to text.
**<math>n</math> refers to text.
*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
**n refers to a number.
**n refers to a number.
*[[Manuals/calci/ISARRAY| ISARRAY(n)]]
*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]
*[[Manuals/calci/ISPMT| ISPMT(n)]]
*[[Manuals/calci/ISPMT| ISPMT(n)]]
*[[Manuals/calci/ISEMPTY| ISEMPTY(n)]]
*[[Manuals/calci/ISEMPTY| ISEMPTY(n)]]