ISBLANK

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

The ISBLANK function returns TRUE if the specified cell is blank or empty. It returns FALSE if the cell 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 behaves similarly to ISBLANK and can also be used to check for blank or empty values.

Syntax

ISBLANK(value)

Arguments

value - The value to evaluate. Required.

Return value

Either TRUE or FALSE.

Example

IF(ISBLANK([2027 Plan]),0,[2027 Plan])

In this example, the ISBLANK function checks whether the 2027 Plan is blank and returns TRUE or FALSE accordingly. If TRUE, it returns 0; otherwise, it returns the existing value of the 2027 Plan.

Applying ISBLANK or ISEMPTY function

Excel equivalent

ISBLANK, ISEMPTY