Cell has a formula in it, if value is zero display empty?

[MegglesZ]

Hey guys

I have a formula in I1 that is based on data being entered in H1.

I want I1 to show as blank/empty, rather than 0.00 if H1 has no data in it, until something is entered.


How do I do that, and do I put it before the formula that's already in there? Is there something I need to put to have 2 formulas in one line?


Newbie question, sorry if it's a bit silly.


Thanks

[Olly]

Something like:

Please Login or Register  to view this content.

Replace XXX with your existing formula.

[MegglesZ]

Something like:

Please Login or Register  to view this content.

Replace XXX with your existing formula.

That was way easier than I was making it hehe

Thanks a bunch :D

[peterrc]

Alternatively, click on the Office Button - Excel Options - Advanced, scroll down to "Display options for this worksheet" and remove the "tick" from "Show a zero in cells that have zero value".

Regards

peterrc