If a cell is empty, ISBLANK returns TRUE.
If a cell contains any value, ISBLANK returns FALSE.
ISBLANK function takes one argument,value, which is a cell reference like A1.
Notice the result in cell C8 is FALSE even though cell B8 looks empty.
However, because cell B8 contains a single space, it is not empty.
Notice this exactly reverses the results seen with ISBLANK alone.
For step-by-step instructions,see this example.
This can cause problems when the goal is to count or process blank cells that include empty strings.
One workaround is to use theLEN functionto test for a length of zero.
ISEVEN will return the #VALUE error if a value is not numeric.
When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
ISNONTEXT Function
The Excel ISNONTEXT function returns TRUE when a cell contains any value except text.
This includes numbers, dates, times, errors, and formulas that do not return text.
ISNONTEXT also returns TRUE when a cell is empty.
ISODD will return the #VALUE error if a value is not numeric.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.
you could use the ISREF function to check for a reference in a formula.
