Thread: Return blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
m[_2_] m[_2_] is offline
external usenet poster
 
Posts: 1
Default Return blank

=if(sum(b4:B13),"",sum(b4:B13))

B14=0?
"Darts via OfficeKB.com" <u19990@uwe 写入消息新闻:8db1234ab38e4@uwe...
here is my formula return 0 how can i get it to return blank

also how do i correct the bottom formula

=IF((C14/B14)," ",(C14/B14) this returns #DIV/0!

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