writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 39:
Line 39: − − − 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.
Manuals/calci/IS FUNCTIONS (view source)
Revision as of 11:17, 11 December 2013
, 11:17, 11 December 2013→Description
*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.