Thread: 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 Return blank not 0
In cell h6 this is my formula however i want the return to be blank if
nothing is in these cells it now return 0 how do i write to return blank
=SUM(C6*2)+(E6*3)+(G6*1)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Reply With QuoteReply With Quote