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,('4BallEntrie s'!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.
--
Grimwadec


"MidlandC" wrote:

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
--
Charles


"David Biddulph" wrote:

No.
--
David Biddulph

"Mike H." wrote in message
...
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?