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.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mike H." wrote:

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?

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.


In article ,
Mike H. wrote:

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?

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?

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.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"JE McGimpsey" wrote:

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.


In article ,
Mike H. wrote:

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?

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




"Pranav Vaidya" wrote in message
...
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.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"JE McGimpsey" wrote:

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.


In article ,
Mike H. wrote:

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?

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

"Mike H." wrote:

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?

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?

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?