Forum Discussion
ABU MUHAMMAD ALBALIGHI
May 07, 2018Copper Contributor
if function in excel
Hi, how to hide the 0 in the red circle?? Is the formula used correct??
SergeiBaklan
May 07, 2018MVP
One of the way
=IF(SUM(C40:V40)=0,"",SUM(C40:V40))
Another way is to use
=SUM(C40:V40)
and apply custom format to resulting cell like
General;General;;@
And one more is to disable Show zero in options
- ABU MUHAMMAD ALBALIGHIMay 08, 2018Copper Contributor
thank you very much sir SergeiBaklan