Aug 06 2020 05:43 AM
Hello, I'm trying to add an 'IF' statement in Excel. I'm adding cells and want to show the sum of the cells, but if the sum result is zero, I want the cell to be blank. Is this possible? Thank you
Aug 06 2020 06:20 AM
It would have been better to attach a sample workbook than a Word document with a picture that doesn't explain anything.
But you can change a formula such as
=SUM(A2;H2)
to
=IF(SUM(A2:H2)=0,"",SUM(A2:H2))