Blank cells, or not.

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

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
 
G

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top