Thread: If cell value =0 then show ""
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geo Geo is offline
external usenet poster
  
Posts: 66
Default If cell value =0 then show ""
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
--
Geo
Reply With QuoteReply With Quote