Microsoft Excel logo.

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.

Select a cell.

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)

Enter the ISBLANK function.

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.

The result of the ISBLANK function.

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.

Choose a cell.

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.

The result of the IF and ISBLANK functions.

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