Empty Cell Result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In this if statement: IF(A1=100,1,"") I would like the 3rd parameter to not
return "", not return 0 but return NOTHING. Is there a way to return empty,
blank, etc?
 
Check the Cell type of the cell you are entering formula, it should be
general and not number.
 
No. Formulae always return values to their calling cells.

You could replace the formulas with an Event Macro.

Or there may be alternatives, depending on what you're using the results
for.
 
That;s right..but then how about changing the cell type to Custom and then
setting it to #, by this even if there is a zero, it will not be displayed.

I agree this will work only for display purpose, which what I think Mike
wants.
 
Why do you think Mike wants that since he says?

"I would like the 3rd parameter to not return "", not return 0 but return
NOTHING. Is there a way to return empty, blank, etc?"

To me it sounds as though he wants a truly empty cell which cannot be done
through a formula since the cell holds the formula


--


Regards,


Peo Sjoblom
 
Mike

You cannot create an empty/NOTHING cell if it has a formula in it.

"" makes the cell look blank only


Gord Dibben MS Excel MVP
 
I thank all who have contributed. It sounds like what I'm asking for is a
change, so I would propose a new function NULL() which returns nothing. Thus
my formula now becomes

=If(isblank(a1),null(),a1)

I've seen this in other languages, so should not be hard to implement.

The reason I want nothing there is I want alpha strings that exceed the size
of the cell to the left to be able to encroach into the cell (if it is truly
blank).

Charles
 
And here we are a year or so later and I looked at this subject and found it
didn't solve my problem in a Golf Draw program I am designing so I came up
with the very simple idea of referring to an empty cell thus:

=IF(ISBLANK('4BallEntries'!A13),$I$1,('4BallEntries'!A13))

in my case a reference to a cell in another worksheet ('4BallEntries'!A13)
which if empty I want the subject cell to be empty so I made reference to an
empty cell, namely I1, and it works perfectly.
 
Back
Top