View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UpGrade UpGrade is offline
external usenet poster
 
Posts: 10
Default Remove Zero Formula

On Tue, 07 Apr 2009 14:38:58 -0600, Glenn wrote:

TGalin wrote:
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?


=IF(your_formula=0,"",your_formula)


Exactly.