Learn How to Use Microsoft Excel ISBLANK Function

Microsoft Excel ISBLANK Function

The main function of the Microsoft Excel ISBLANK function is to get the information about the cell whether it's blank or not. It implies with the help of the ISBLANK function you can able to get the return value will be TRUE if the particular cell is empty, and FALSE in case it is not empty. Let us understand more about it with the help of the examples given below.        

Return Value of ISBLANK Function

The return value will be the logical TRUE or FALSE.

Syntax of ISBLANK Function

=ISBLANK(value)

Where the arguments:

• value: It is the value to check.

How to Use Microsoft Excel ISBLANK Function?

You can use the ISBLANK function to get the information about the cell whether it is empty or not. The ISBLANK will return TRUE if the cell is empty and return FALSE in case the cell is not empty. You can understand this by the examples given in the picture. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel