Thread: Return blank
View Single Post
  #3   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

m wrote:
=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!


b14 is returning 0 i would like for it to be blank

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