Excel formula: If cell is not blank

Generic formula

=IF(A1<>"","Not blank","Blank")

Explanation

If you want to test a cell and take some action if the cell is not blank (not empty), you can use a simple formula based on the IF function.

In the example shown, we have a simple task list with a date complete in column D. In column E, we have a formula that checks cells in column D to see if they are empty or not. When a cell is blank, the formula assigns a status of "Open". If the cell contains a value (a date in this case, but it could be anything) the formula will assign a status of "Closed". The formula in cell E5 is:

=IF(D5<>"","Closed","Open")

The <> is a logical operator that means "not equal to".

The effect of showing "Closed" in light gray is accomplished with a conditional formatting rule.

Display nothing if cell is not blank

If you only want to display a value if a cell is not blank, you can replace the "value if false" argument in the IF function with an empty string (""). The formula would then be:

=IF(D5<>"","Closed","")

Alternative with ISBLANK

Excel contains a function dedicated to testing for empty cells called ISBLANK. To use the ISBLANK function in this case, instead of the A1<>"" syntax, you would wrap ISBLANK inside the NOT function like this:

=IF(NOT(ISBLANK(D5)),"Closed","Open")

Author

Dave Bruns

Related formulas

If cell is blank

To test a cell and take some action if the cell is blank (empty), you can use the IF function. The formula in cell E5 is: = IF ( D5 = "" , "Open" , "Closed" ) How this formula works The logical expression ="" means "is...

If cell contains

If you want to copy cells that contain certain text, you can use a formula that uses the IF function together with the SEARCH and ISNUMBER functions. Once you find a value you're looking for you can copy it to another location, or display a message...

Related functions

Excel IF Function

The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions....

Excel ISBLANK Function

The Excel ISBLANK function returns TRUE when a cell contains is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.

Excel NOT Function

The Excel NOT function returns the opposite of a given logical or boolean value. When given TRUE, NOT returns FALSE.When given FALSE, NOT returns TRUE. Use the NOT function to reverse a logical value.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.