Quote:
Originally Posted by macropod
No, it'll only hide 0s in the cells to which the custom format is applied.
|
Please note the OP's question; the part where it refers to "cell formatting".
Also,
Quote:
Originally Posted by macropod
IF(OR(A1=0,B1=0),"",A1+B1)
|
Your formula would work better as:
Code:
IF(AND(A1=0,B1=0),"",A1+B1)
to avoid the embarrassment of 0+4=""