Return blank

[Darts via OfficeKB.com]

here is my formula =sum(b4:B13) 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!

 

[m]

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

B14=0?

 

[Darts via OfficeKB.com]

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

B14=0?

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

 

[Pete_UK]

I didn't realise you had posted earlier. Try this for your first
query:

=IF(SUM(B4:B13)=0,"",SUM(B4:B13))

For your second query, see my response to your other post.

Hope this helps.

Pete