If cell value =0 then show ""

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following formula:

=SUM(D20:H20)/5
How can I add the following to the formula: (G41=0,"",)
I need it to show an empty cell if the figure is 0.
Thank you
 
Another option is to go to Tools > Options > View and deselect the "Zero
values" tickbox.
 
Back
Top