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?