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.

A cell with a formula-blank can never be truly empty, as the cell
contains a formula !! The formula blank is really a zero-length text
string, which explains the results you get with ISBLANK and ISTEXT.

I'm not sure how you can get round this.

Pete

On Apr 8, 1:26*pm, Dave wrote:
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.

=IF(A1=0,"cell has zero in it, or a formula return the null, or is truly
empty","")
=IF(A1="","cell is either truely empty or a formula returning a null","")
=IF(ISBLANK(A1),"cell is truly empty","")

You can combine these:

=IF(AND(A1=0,A1<""),"cell has a genuine zero","")
--
Gary''s Student - gsnu200777


"Dave" wrote:

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.

Try these:
=isblank()
=code()
a space will be ASCII code 32
leading code will be ASCII 160
A full list can be seen he
http://www.physik.fu-berlin.de/~goerz/misc/ascii.gif


Regards,
Ryan---


--
RyGuy


"Gary''s Student" wrote:

=IF(A1=0,"cell has zero in it, or a formula return the null, or is truly
empty","")
=IF(A1="","cell is either truely empty or a formula returning a null","")
=IF(ISBLANK(A1),"cell is truly empty","")

You can combine these:

=IF(AND(A1=0,A1<""),"cell has a genuine zero","")
--
Gary''s Student - gsnu200777


"Dave" wrote:

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.

Hi,
I guess the question I'm asking is:
Is there a function or formula that will return a truly blank cell if a
required condition is not met?
Dave.

No.

Pete

On Apr 8, 2:38*pm, Dave wrote:
Hi,
I guess the question I'm asking is:
Is there a function or formula that will return a truly blank cell if a
required condition is not met?
Dave.

no
--
Gary''s Student - gsnu200777


"Dave" wrote:

Hi,
I guess the question I'm asking is:
Is there a function or formula that will return a truly blank cell if a
required condition is not met?
Dave.

Bother! (said Pooh)
Ok, thanks.
Dave.