[ad_1]
You can use Excel’s ISBLANK function with a cell reference as argument, for example “=ISBLANK(A1)”, to check if that cell is blank or not. Combine it with other functions to perform actions based on the result.
MS Excel ISBLANK The function allows you to check if a cell is blank or not. You can use this function together with the IF function to determine what happens to your cells when they are blank or non-blank. Here is how to do it.
RELATED: How to count blank or empty cells in Microsoft Excel
What is the ISBLANK function in Excel?
Excel ISBLANK The function allows you to check if the specified cell is blank or not. If the cell is blank, the function retrieves a TRUE worth. If the cell is not blank, you will get a FALSE worth. You can use these values ​​with other Excel functions, such as IF to perform actions on or in response to your blank and non-blank cells.
The syntax of the ISBLANK function is:
=ISBLANK(value)
Here, value refers to the reference of the cell you want to check. So if you want to check if cell A1 is blank or not, you have to insert A1 instead of value.
Excel also offers other functions for working with blank cells, such as COUNTBLANK that gives you the total count of blank cells in the specified range. If you already know if a cell is blank or not, but want to know what type of value it contains, you can use functions like ISNUMBER to check if a specific cell contains any numbers, or ISTEXT to check if a cell has a text value.
RELATED: How to use the IS functions in Microsoft Excel
Check if a cell is blank with Excel’s ISBLANK function
To use the function, first, open your spreadsheet with the Excel application and click on the cell where you want to display the result of the function.
In the selected cell, type the following function and press Enter. In this function, replace C2 with the cell you want to query.
=ISBLANK(C2)
To use the function for all of your records in the spreadsheet, from the bottom right corner of the cell where you entered the function, drag down covering all of its rows.
Now you know which cell is and which cell is not blank in your spreadsheet.
RELATED: How to fill Excel cells automatically with Flash Fill and Auto Fill
Perform an action when a cell is blank or not blank
Often you may want to take an action based on the state of your cell. You may want to display a message that says something when your cell is blank, and says something else when your cell is not blank.
To do that, combine the ISLBLANK function with excel IF function.
First, open your spreadsheet with Excel. Then click on the cell where you want to display the result of your function.
In your selected cell, type the following function and press Enter. Here, replace C2 with the cell you want to check (if it is blank or not), Sale Not Made with the text you want to use if the cell is blank, and Sale Made with the text if the cell is not blank.
=IF(ISBLANK(C2),"Sale Not Made","Sale Made")
To use the function for all your records in the spreadsheet, from the bottom right corner of the cell where you entered the function, drag down covering all your records.
And now you have your chosen text displayed for your blank and non-blank cells.
RELATED: How to skip pasting blank cells when copying in Microsoft Excel
[ad_2]
