信息公式

关键词:  信息公式

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)