Empty Cell Result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike H. - 26 Sep 2007 14:38 GMT

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?

Reply to this Message

Pranav Vaidya - 26 Sep 2007 14:52 GMT

Check the Cell type of the cell you are entering formula, it should be
general and not number.

Signature

Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

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

Reply to this Message

Gord Dibben - 26 Sep 2007 18:04 GMT

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

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

Reply to this Message

JE McGimpsey - 26 Sep 2007 15:23 GMT

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

Reply to this Message

Pranav Vaidya - 26 Sep 2007 15:36 GMT

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.

Signature

Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

> No. Formulae always return values to their calling cells.
>
[quoted text clipped - 6 lines]
> > return "", not return 0 but return NOTHING. Is there a way to return empty,
> > blank, etc?

Reply to this Message

Peo Sjoblom - 26 Sep 2007 15:42 GMT

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

Signature

Regards,

Peo Sjoblom

> 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
[quoted text clipped - 15 lines]
>> > empty,
>> > blank, etc?

Reply to this Message

David Biddulph - 26 Sep 2007 15:33 GMT

No.

Signature

David Biddulph

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

Reply to this Message