Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
If function - Add if its blank, to return blank | Excel Worksheet Functions | |||
If cell blank return a blank | Excel Worksheet Functions | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
How do I return the first non-blank value in a row? | Excel Worksheet Functions |