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)

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

Picture 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?

Picture 2 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)

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

- Press Enter -> return value is:

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

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

Picture 5 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!

You've just finished reading the article "ISBLANK function - The function checks if a cell is a blank value in Excel" edited by the TipsMake team. You can save isblank-function-the-function-checks-if-a-cell-is-a-blank-value-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : ISERR function -...
Rotate 3D graphs in... : NEXT »