Quote:
Originally Posted by ConneXionLost
Please note the OP's question; the part where it refers to "cell formatting".
|
Your point being?
Your advice:
is plain wrong. It will only hide 0s in the cells to which the custom format is applied - not all cells in the worksheet.
As for:
Quote:
Originally Posted by ConneXionLost
Your formula would work better as:
Code:
IF(AND(A1=0,B1=0),"",A1+B1)
to avoid the embarrassment of 0+4="" |
I was quite deliberate in using the OR statement, for the reasons I gave. With your variant, if -A1=B1, you'll still get a 0 display.