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
|