Discussion on:

Message 12 of 12
0 Votes
+ -
I Use A Formula to Hide Zeros When Using An Equation If Needed
If using a formula and you want the cell appear blank if the result is zero, build a IF statement around the formula. That way if I change the font or background color of the cell it does not affect the hidden zero. Example:

=IF(SUM(A4:A5)=0,"",SUM(A4:A5))
Posted by hws1947@...
26th Jun