View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Archimedes' Lever Archimedes' Lever is offline
external usenet poster
 
Posts: 63
Default Remove Zero Formula

On Tue, 7 Apr 2009 12:33:01 -0700, 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?



Put it inside an IF statement that tests for it, and returns "" instead
of 0.