Thread: Cell to return blank not 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darts via OfficeKB.com Darts via OfficeKB.com is offline
external usenet poster
  
Posts: 29
Default Cell to return blank not 0
In cell b14 this is my formula - if these cells are blank i want the return
to be blank it is giving me a return of 0
=if(sum(b4:B13),"",sum(b4:B13))

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote