ISBLANK
TheISBLANK
formula is used to check if a cell is empty. It returns TRUE
if the cell is empty and FALSE
if it contains any data or formula. This formula is commonly used in conditional formatting or data validation rules to ensure a cell is not left empty.
 How to use
ISBLANK
formula?  Examples of using
ISBLANK
formula ISBLANK
formula not working? Similar formulas to
ISBLANK
Usage
Use the ISBLANK
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The cell or range of cells to check for emptiness.
Examples
Here are a few example use cases that explain how to use theISBLANK
formula in Google Sheets.
Checking for empty cells in a range
You can use the ISBLANK
formula to check if any cells in a range are empty. This is useful when you need to ensure all cells in a range have been filled before proceeding with a calculation or analysis.
Creating data validation rules
By using the ISBLANK
formula in a data validation rule, you can ensure that a user cannot submit a form or input data without filling in all required fields.
Conditional formatting based on cell emptiness
You can use the ISBLANK
formula in conditional formatting rules to highlight or format cells that are empty. This can help draw attention to cells that need to be filled in or completed.
Common Mistakes
ISBLANK
not working? Here are some common mistakes people make when using the ISBLANK
Google Sheets Formula:
Misunderstanding the function's purpose
Users may incorrectly assume that ISBLANK checks for empty cells when in reality it only checks for cells with no value or formulas that return empty values.
Not using the correct syntax
Users may incorrectly use the wrong syntax for the function, such as omitting the value parameter or using incorrect syntax for referencing a cell or range.
Using the function with nonblank cells
Users may incorrectly use the function with cells that have values, which will always return FALSE.
Related Formulas
The following functions are similar to ISBLANK
or are often used with it in a formula:

IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
COUNTBLANK
The
COUNTBLANK
formula is a mathematical formula that counts the number of blank cells within a given range. It is commonly used for data analysis and quality control. 
LEN
The
LEN
formula in Google Sheets is used to count the number of characters in a given text string. It is commonly used to check the length of text inputs, or to find the length of a cell value or range. 
ISTEXT
The
ISTEXT
function checks whether the value provided is a text string or not. It returns TRUE if the value is text and FALSE if it is any other data type. This function is commonly used when working with data sets that contain text and nontext values.
Learn More
You can learn more about the ISBLANK
Google Sheets function on Google Support.