Category: Excel Formulas

The ISNONTEXT Function is to check whether a value is not text. When the value is not text, the result returns TRUE. Formula: =ISNONTEXT(value) Explanations: Value is required, the …

The ISNA Function is to check whether a value is #N/A error. Formula: =ISNA(value) Explanations: Value is required, the result returns TRUE when the value is #N/A error, and …

The ISLOGICAL Function checks whether a value is logical value. When it is a logical value, the result returns to "TRUE", and returns "FALSE" when it is not. Formula: …

The ISODD Function checks whether a value is an odd number. When it is an odd number, the result returns to "TRUE", and returns "FALSE" when it is not …

ISERROR Function checks whether a value is an error of #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, or #N/A. Formula: = ISERROR(value) Explanations: Value is required, when the value is …

The ISERR Function checks whether a value is an error of #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, except #N/A error. Formula: = ISERR(value) Explanations: Value is required, when the …