Blank cells, or not.

[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.

 

[Pete_UK]

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

 

[Gary''s Student]

=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","")

 

[ryguy7272]

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


Regards,
Ryan---

 

[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.

 

[Pete_UK]

No.

Pete

 

[Gary''s Student]

no

 

[Dave]

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

 

[Gary''s Student]

If you are willing to use macros, a macro can either clear a cell or put a
value/formula in the cell automatically based upon arising conditions.

 

[Dave]

Hi,
Yeah, that's what I was coming around to.
Thanks.
Dave/