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.
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.

Excel equivalent
Last updated
Was this helpful?