D
Dave
Hi,
I posted this question yesterday, or thought I did, but now can't find it.
Sorry if someone has already gone to the trouble of answering. I will tick
the "Notify me of replies" box this time.
Consider the following formula.
=IF(A1=0,"",A1)
When A1=0, the cell in which the formula resides appears blank.
But an ISBLANK test returns FALSE, and an ISTEXT test returns TRUE.
Since "" doesn't return a truly blank cell, what can I use instead?
Having text cells masquerading as blanks, is messing up a Dynamic Named
Range I am trying to create.
Regards - Dave.
I posted this question yesterday, or thought I did, but now can't find it.
Sorry if someone has already gone to the trouble of answering. I will tick
the "Notify me of replies" box this time.
Consider the following formula.
=IF(A1=0,"",A1)
When A1=0, the cell in which the formula resides appears blank.
But an ISBLANK test returns FALSE, and an ISTEXT test returns TRUE.
Since "" doesn't return a truly blank cell, what can I use instead?
Having text cells masquerading as blanks, is messing up a Dynamic Named
Range I am trying to create.
Regards - Dave.