Thread: Remove Zero Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TGalin TGalin is offline
external usenet poster
  
Posts: 81
Default Remove Zero Formula
How can I change this formula =SUM(B5:D5) so that it will return a blank cell
instead of a zero if B5:D5 is empty?
Reply With QuoteReply With Quote