ISBLANK Function – Google Sheets

ISBLANK Function Summary

ISBLANK Purpose

ISBLANK is a function that is typically used in formulas. Many formulas are designed to return different values depending if a specific cell is blank or not.

ISBLANK Syntax

Elements of the function

=ISBLANK(value)

• Function name
• value- [Required] The reference cell to return a boolean function depending upon the reference cell containing content

Arguments of the function

The ISBLANK function returns either a TRUE or FALSE value depending if the referenced cell has contents.

ISBLANK Notes

• Even a cell containing only a space, may appear empty, but ISBLANK will return a FALSE value.
• Commonly used with IF formulas to prevent returning an error if not all necessary variables are entered for a formula to produce the desired value.
• Even if a cell contains an error ISBLANK will recognize this as a nonempty cell and return FALSE.

ISBLANK Example Spreadsheet

Keyboard Shortcuts

Windows	Mac
Control (Ctrl) + Shift (⇧) + Arrow	Command (⌘) + Shift (⇧) + Arrow
Purpose: Highlight all cells in a column	Purpose: Highlight all cells in a column or row

Related Functions

• IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
• ISTEXT: Checks whether a value is text.
• ISREF: Checks whether a value is a valid cell reference.
• ISNUMBER: Checks whether a value is a number.
• ISNONTEXT: Checks whether a value is non-textual.
• ISNA: Checks whether a value is the error `#N/A`.
• ISLOGICAL: Checks whether a value is `TRUE` or `FALSE`.
• ISERROR: Checks whether a value is an error.
• ISERR: Checks whether a value is an error other than `#N/A`.