Clear, practical technology insights About · Contact

ISBLANK function - The function checks if a cell is a blank value in Excel

ISBLANK function: The function checks whether a cell is a blank value or not. The function returns True if it is blank and vice versa is False. Syntax: ISBLANK (value)

Author: Jessica Tanner2 minutes read

The following article introduces you to ISBLANK function - one of the functions in the information function group is very popular in Excel.

images 1 of ISBLANK function - The function checks if a cell is a blank value in Excel

Description: The function checks whether the cell is a blank value or not. The function returns True if it is blank and vice versa is False.

Syntax: ISBLANK (value)

Inside:

- value: The value you want to determine is a blank value or not, is a required parameter.

Attention:

- The function returns True value if it is blank and returns False if it is not blank.

For example:

Check if the value in the value is blank?

images 1 of ISBLANK function - The function checks if a cell is a blank value in Excel

- In the cell to calculate, enter the formula : = ISBLANK (C6)

images 1 of ISBLANK function - The function checks if a cell is a blank value in Excel

- Press Enter -> return value is:

images 1 of ISBLANK function - The function checks if a cell is a blank value in Excel

- Similarly copying the formula for the remaining values ​​results:

images 1 of ISBLANK function - The function checks if a cell is a blank value in Excel

Above are instructions and some specific examples when using ISBLANK function in Excel.

Good luck!

Was this article helpful?

Your feedback helps us improve.

Discussion

Reader Comments 0

Sign in with email or Google to join the discussion.