Quote Originally Posted by Jamidd1 View Post
please see attached workbook sample.
Don't see an attachment.

The ISBLANK function is not correctly named based on its characteristics.

It should have been named ISEMPTY.

If a cell contains a formula blank "" ISBLANK returns FALSE which you would not expect it to!

Better to use logic statements like:

=A1="" (A1 is blank/empty)

=A1<>"" (A1 is not blank/empty)