MS Excel Related functions: If the cell isn’t blank

Generic formula



To perform an action only when the cell is empty (not empty) You can apply formulas based on INF function. In the example in column D, the column holds the dates for task completion. The formula used in cell E5 reads:



In this case column D is the date that a job was finished. Thus, if column D has the date (i.e. isn’t blank) We can conclude that the task is done.

Cell E5 utilizes the IF function to determine whether D5 can be said to “not empty”. If not, the output will be “Done”. If D5 is empty IF results in an empty string (“”) that displays nothing”


The symbol > is an logic operator which is “not equal to”, thus”not equivalent to” <>”” is “not nothing” or “not empty”. If column D has a value, it is TRUE, and IF is returned as “Done”. If column D is unfilled, the output will be False and If results in an empty string. (“”).

Two results

To show simultaneously “Done” and “Not done” You can alter the formula in this way:

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


Another option is to make use of instead the functions ISBLANK to look for blank cells. The ISBLANK function returns TRUE if cells are empty and returns FALSE in the absence of. If you want to use ISBLANK, you could modify the formula as follows: this:


Note that the TRUE and FALSE results are switched. Now the logic is when cell D5 is blank..

To preserve the original logic and sequence You can also add an not function in the following manner:


Posted in Excel