hi
you didn't give enough info to write a proper formula so i'll have to make
one up.

=if(A1+B1=0,"",A1+B1)

or if the formala A1+B1 = 0, display nothing, else desplay the formula
results.

Regards
FSt1

"DeeDeeCee" wrote:

I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the
rows, there is no "input" data, and so the calculation simply indicates the
answer is zero. This gives me a column with lots of zero's in the cells. I'd
prefer there simply to be a blank cell, whenever the result of the formula is
zero. Is there a way to achieve that?

Thanks much.

ddc