On Dec 26, 5:09=A0pm, Gary F Shelton
I would use:
=3Dif(A1=3D"", "Null", "Not Null")
This works whether A1 is truly empty (does not contain a formula or
value) as well as if A1 appears empty because it has a formula that
results in the null string ("").
ISBLANK() is true only if the cell is truly empty (no formula or