Posted By: Anonymous
I would like to write an IF statement, where the cell is left blank if the condition is FALSE.
Note that, if the following formula is entered in C1 (for which the condition is false) for example:
and if C1 is tested for being blank or not using
=ISBLANK(C1), this would return
FALSE, even if C1 seems to be blank. This means that the
=IF(A1=1,B1,"") formula does not technically leave the cells blank if the condition is not met.
Any thoughts as to a way of achieving that? Thanks,
Try this instead
This will return true for cells that are either truly blank, or contain nothing but white space.
See this post for a few other options.
To reflect the comments and what you ended up doing: Instead of evaluating to “” enter another value such as ‘deleteme’ and then search for ‘deleteme’ instead of blanks.