Return blank
 

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!

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

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

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

Return blank
 

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

On Nov 25, 1:12*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
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 viahttp://www.officekb.com