What is ISBLANK function in Excel?
The ISBLANK function is one of the Information functions of Excel.
It Checks whether a reference is to an empty cell, and returns TRUE or FALSE.
We can find this function in Information category of the insert function Tab.
How to use ISBLANK function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISBLANK function
6. Then select ok.
7. In the function arguments Tab you will see ISBLANK function.
8. Value section is the cell or a name that refers to the cell you want to test.
9. You will see the results in the formula result section.
Examples of ISBLANK function in Excel
ISBLANK related functions
- Use ISERROR function to check whether a value is an error, and return TRUE or FALSE.
- Use ISNONTEXT function to check whether a value is not text, and return TRUE or FALSE.
- Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.
- Use ISTEXT function to check whether a value is text, and returns TRUE or FALSE.
