ISBLANK

Checks whether a cell is blank and returns TRUE or FALSE.

The ISBLANK function returns TRUE if the specified value is blank or empty. It returns FALSE if the value contains any text, number, or expression. It is commonly used with IF and other logical functions to validate missing values before performing calculations.

The ISEMPTY function works similar to ISBLANK and can also be used to check for blank or empty values.

Syntax

ISBLANK(value)

Arguments

• value - The value to evaluate.

Return value

Returns TRUE if the value is blank; otherwise, returns FALSE.

Example

IF(ISBLANK(2027 Actuals Plan), 0, 2027 Actuals Plan)

In this example, the ISBLANK function checks whether the 2027 Actuals Plan value is blank. If the condition is TRUE, the formula returns 0; otherwise, it returns the existing value.

Excel equivalent

ISBLANK, ISEMPTY