| Formulas | Description | Examples |
|---|---|---|
| ISBLANK | Syntax: ISBLANK(value) This function is used to check for blank or null values. |
=ISBLANK(A1) |
| ISERROR | Syntax: ISERROR(value) Returns TRUE if value is an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL). |
=ISERROR(A1) |
| ISERR | Syntax: ISERR(value) Returns TRUE if value is an error value (except #N/A). |
=ISERR(A1) |
| ISEVEN | Syntax: ISEVEN(number) Returns TRUE if number is even, or FALSE if number is odd. |
=ISEVEN(A1) =ISEVEN(5) |
| ISLOGICAL | Syntax: ISLOGICAL(value) This function is used to check for a logical value (ie: TRUE or FALSE). |
=ISLOGICAL(TRUE) =ISLOGICAL("FALSE") |
| ISNA | Syntax: ISNA(value) Returns TRUE if value is not available. |
=ISNA(A1) |
| ISNUMBER | Syntax: ISNUMBER(value) Returns TRUE if value is number, or FALSE if value is not number. |
=ISNUMBER(A1) =ISNUMBER(1234) |
| ISODD | Syntax: ISODD(number) Returns TRUE if number is odd, or FALSE if number is even. |
=ISODD(2.5) =ISODD(5) =ISODD(A1) |
| ISTEXT | Syntax: ISTEXT(value) Returns TRUE if value is a text value, or FALSE if value is not a text value. |
=ISTEXT(A1) =ISTEXT("string") |
| N | Syntax: N(value) This function converts a value to a number. If value is a date, the N function returns the date as a serial number. If value is boolean - true/false, the N function returns 1/0. |
=N(A1) =N("8") |
| NA | Syntax: NA() This function returns the error value #N/A. |
=NA() |
| TYPE | Syntax: TYPE(value) Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell. |
=TYPE(value) |