You need to use Excel’s ISBLANK perform with a cell reference because the argument, for instance “=ISBLANK(A1)”, to verify if that cell is clean or non-blank. Mix it with different features to carry out actions relying on the end result.
Microsoft Excel’s ISBLANK
perform allows you to verify whether or not a cell is clean or not. You need to use this perform at the side of the IF
perform to find out what occurs to your cells once they’re clean or non-blank. Right here’s easy methods to do it.
RELATED: How to Count Blank or Empty Cells in Microsoft Excel
What Is the ISBLANK Operate in Excel?
Excel’s ISBLANK
perform permits you to verify if the desired cell is clean or not. If the cell is clean, the perform retrieves a TRUE
worth. If the cell just isn’t clean, you get a FALSE
worth. You need to use these values with different Excel features, like IF
, to carry out actions on or in response to your clean and non-blank cells.
The syntax of the ISBLANK
perform is:
=ISBLANK(worth)
Right here, worth
refers back to the reference of the cell that you just wish to verify. So if you wish to verify whether or not or not cell A1 is clean, you’d insert A1
rather than worth
.
Excel additionally gives different features for working with clean cells, like COUNTBLANK
that offers you the total count of blank cells within the specified vary. If you happen to already know whether or not a cell is clean or not however wish to know what sort of worth it accommodates, you should use features like ISNUMBER
to verify if a specified cell accommodates any numbers, or ISTEXT
to verify if a cell has a textual content worth.
RELATED: How to Use the IS Functions in Microsoft Excel
Test If a Cell Is Clean With Excel’s ISBLANK Operate
To make use of the perform, first, open your spreadsheet with the Excel app and click on the cell the place you wish to show the perform’s end result.
Within the chosen cell, sort the next perform and press Enter. On this perform, exchange C2
with the cell that you just wish to verify.
=ISBLANK(C2)
To use the function for all your records within the spreadsheet, from the bottom-right nook of the cell the place you entered the perform, drag downwards masking all of your rows.
Now what cell is and isn’t clean in your spreadsheet.
RELATED: How to Fill Excel Cells Automatically with Flash Fill and Auto Fill
Carry out an Motion When a Cell Is Clean or Non-Clean
Usually, it’s possible you’ll wish to perform an action depending on your cell’s status. You could wish to show a message that claims one thing when your cell is clean and says one thing else when your cell isn’t clean.
To try this, mix the ISLBLANK
perform with Excel’s IF
perform.
First, open your spreadsheet with Excel. Then, click on the cell the place you wish to show your perform’s end result.
In your chosen cell, sort the next perform and press Enter. Right here, exchange C2
with the cell that you just wish to verify (if it’s clean or not), Sale Not Made
with the textual content you wish to use if the cell is clean, and Sale Made
with the textual content if the cell just isn’t clean.
=IF(ISBLANK(C2),"Sale Not Made","Sale Made")
To make use of the perform for all of your data within the spreadsheet, from the bottom-right nook of the cell the place you’ve entered the perform, drag downwards masking all of your data.
And also you now have your chosen textual content displayed to your clean and non-blank cells.
RELATED: How to Skip Pasting Blank Cells When Copying in Microsoft Excel
Source link