• # Information

• ## TYPE

Returns a number specifying the type of the given value.   Syntax   TYPE(value) value: The value given as input. E.g. TRUE TYPE function returns: 1 - if value is a number 2 - if value is a text 4 - if value is a boolean 16 - if value is an error 64 - ...
• ## NA

Returns the #N/A error value.   Syntax   NA()   Remarks The value #N/A! can be directly used in the cell instead of =NA() too. Examples     Formula Result =NA() #N/A! Get a hands-on experience of the function in the embedded range below.    Possible ...
• ## N

Returns the numeric value of a given argument.   Syntax   N(value) value: Number, text, or logical expression whose numeric value you want. N returns 0 for text, 1 for TRUE, and 0 for FALSE values. E.g. "Zoho"   Examples   Formula Result =N("Zoho") 0 ...
• ## ISTEXT

Returns TRUE if the given value is or refers to text, and FALSE otherwise.   Syntax   ISTEXT(value) value: The value to test. E.g. "Zoho"   Examples   Formula Result =ISTEXT("Zoho") TRUE =ISTEXT(A3) FALSE =ISTEXT(A4) FALSE Get a hands-on experience ...
• ## ISREF

Returns TRUE if the given value is a reference to a cell or range of cells, and FALSE otherwise.   Syntax   ISREF(value) value: The value to test. E.g. A7   Remarks ISREF function returns TRUE for defined names as well. Examples   Formula Result ...
• ## ISODD

Returns TRUE if the given value is an odd number, and FALSE otherwise. Ignores decimal digits and negative signs.   Syntax   ISODD(value) value: The value to test. E.g. 1   Examples   Formula Result =ISODD(1) TRUE =ISODD(A3) TRUE =ISODD(A4) FALSE Get ...
• ## ISNUMBER

Returns TRUE if the given value is a number or a logical value, and FALSE otherwise.   Syntax   ISNUMBER(value) value: The value to test. E.g. 12   Examples   Formula Result =ISNUMBER(12) TRUE =ISNUMBER(A3) FALSE =ISNUMBER(A4) FALSE Get a hands-on ...
• ## ISNONTEXT

Returns FALSE if the given value is or refers to text, and TRUE otherwise.   Syntax   ISNONTEXT(value) value: The value to test. E.g. A2   Examples   Formula Result =ISNONTEXT(A2) FALSE =ISNONTEXT(A3) TRUE =ISNONTEXT(A4) TRUE Get a hands-on ...
• ## ISNA

Returns TRUE if the given value is or refers to the #N/A! (Not Available) error, and FALSE otherwise.   Syntax   ISNA(value) value: The value to test. E.g. A2   Examples     Formula Result =ISNA(A2) TRUE =ISNA(A3) FALSE =ISNA(A4) FALSE Get a hands-on ...
• ## ISLOGICAL

Returns TRUE if the given value is either TRUE or FALSE, and FALSE otherwise.   Syntax   ISLOGICAL(value) value: The value to test. E.g. FALSE   Examples   Formula Result =ISLOGICAL(A2) TRUE =ISLOGICAL(A3) TRUE =ISLOGICAL(A4) FALSE Get a hands-on ...
• ## ISFORMULA

Returns TRUE if the given cell contains a formula, and FALSE otherwise.   Syntax   ISFORMULA(cell) cell: The cell reference to test. E.g. A2   Examples   Formula Result =ISFORMULA(A2) TRUE =ISFORMULA(A3) FALSE =ISFORMULA(A4) TRUE Get a hands-on ...
• ## ISEVEN

Returns TRUE if the value is an even number, and FALSE otherwise.   Syntax   ISEVEN(value) value: The value to evaluate. Signs and decimal numbers are ignored. E.g. 2   Examples   Formula Result =ISEVEN(2) TRUE =ISEVEN(3) FALSE =ISEVEN(-4) TRUE Get a ...
• ## ISERROR

Returns TRUE if the value refers to an error value, and FALSE otherwise.   Syntax   ISERROR(value) value: The cell reference with the value to test. E.g. A2   Examples   Formula Result =ISERROR(A2) FALSE =ISERROR(A3) TRUE =ISERROR(A4) TRUE Get a ...
• ## ISERR

Returns TRUE if the value refers to an error value other than #N/A!, and FALSE otherwise.   Syntax   ISERR(value) value: The cell reference with the value to evaluate. E.g. A2   Examples   Formula Result =ISERR(A2) TRUE =ISERR(A3) TRUE =ISERR(A4) ...
• ## ISBLANK

Returns TRUE if a cell is blank/empty, and FALSE otherwise.   Syntax   ISBLANK(cell) cell: The cell reference to test. E.g. A2   Examples   Formula Result =ISBLANK(A2) FALSE =ISBLANK(A3) TRUE =ISBLANK(A4) TRUE Get a hands-on experience of the ...
• ## FORMULA

Returns the formula present in a cell as a text string.   Syntax   FORMULA(cell) cell: The reference of cell containing the formula. E.g. A2   Examples     Formula Result =FORMULA(A2) =SUM(F1:F5) =FORMULA(A3) =TODAY() =FORMULA(A4) =CELL("WIDTH") Get ...
• ## CURRENT

Returns the current (to date) result of a formula. It can be used in combination with other functions. For example, the function =2+3+CURRENT() returns 10 as the result.   Syntax   CURRENT()   Examples   Formula Result ="co"&CURRENT() coco ...
• ## CELL

Returns information about the address, format, or content of a given cell.   Syntax   CELL(info_type; cell_ref ) info_type: Text string that determines which information to return. E.g. "WIDTH" cell_ref: The reference of the cell whose information ...