Quick, clean, and to the point

If cell is not blank

Excel formula: If cell is not blank
Generic formula 

To take an action only when the cell is not blank (not empty), you can use a formula based on the IF function. In the example shown, column D holds task complete dates. The formula in cell E5 is:


The <> symbol is a logical operator that means "not equal to", so the expression <>"" means "not nothing" or "not empty". When column D contains a value, the result is TRUE and IF returns "Done". When column D is empty, the result is FALSE and IF returns an empty string ("").

Two results

To display both "Done" and "Not done", you can adjust the formula like this:

=IF(D5<>"","Done","Not done")


The ISBLANK function returns TRUE when a cell is empty and FALSE if not. To use ISBLANK, you can rewrite the formula like this:


Notice the TRUE and FALSE results have been swapped. To keep the original sequence, maintain the original idea of <>"", you can add the NOT function:

Dave Bruns

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.