One trick is to allow the formula to return a zero, but "hide" it by
means of conditional formatting on that cell - if the cell content is
zero then print with a white foreground (which on a white background
will not show).

Hope this helps.

Pete

On Jan 15, 12:55*am, Holly wrote:
Hi All,

Just wondering if anyone has found a way for a formula result which
calculates to zero to show as a blank cell.
--
Cheers,
Holly