writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 37:
Line 37: − + − + +
Manuals/calci/IS FUNCTIONS (view source)
Revision as of 11:34, 11 December 2013
, 11:34, 11 December 2013→Description
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 any numbers from text.
*This function will not convert to 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.
*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.