I have a column whose cells are formatted to take one number from Cell A,
another from Cell B, then add them add divide by two (i.e., average them).
The problem is that many of the rows don't have anything in Cell A and B, and
the result shows as "00.00". This gets in the way of seeing the rows where
there is data available, and therefore useful information. Any suggestions on
how to set up my formula so that it just doesn't show if the "result" is 0?

Thanks.

ddc