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?