Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In cell b14 this is my formula - if these cells are blank i want the return
to be blank it is giving me a return of 0 =if(sum(b4:B13),"",sum(b4:B13)) -- Message posted via http://www.officekb.com |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Nov 25, 11:05*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
In cell b14 this is my formula - if these cells are blank i want the return to be blank it is giving me a return of 0 =if(sum(b4:B13),"",sum(b4:B13)) -- Message posted viahttp://www.officekb.com This formula won't work as the if statement is not entirely correct. If Sum(b4:B13) then Null Else Sum(B4:B13) End If There's nothing to compare it against in the If clause..... it should be something like If Sum(B4:B13) = 0 Then Null Else Sum(B4:B13) End If or =IF(sum(b4:b13)=0,"",Sum(B4:B13)) or.... use custom number formats..... Why not use a custom number format on the cell. Something along the lines of this.... _-* #,##0_-;-* #,##0_-;_-* ""?? _-;_-@_- Format Cells Custom If you want decimal places then it would look like..... _-* #,##0.00_-;-* #,##0.00_-;_-* ""??_-;_-@_- If you want a dash (using the decimal places) _-* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_- Try that. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What do you mean by "these cells" -- all cells in the range b4:b13? If so,
try: =if(count(b4:b13)0,sum(b4:b13),"") Regards, Fred. "Darts via OfficeKB.com" <u19990@uwe wrote in message news:8db1c7edb6a62@uwe... In cell b14 this is my formula - if these cells are blank i want the return to be blank it is giving me a return of 0 =if(sum(b4:B13),"",sum(b4:B13)) -- Message posted via http://www.officekb.com |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Try =IF(SUM(B4:B13),SUM(B4:B13),"") This works because if SUM(B4:B13) returns 0 Excel considers it FALSE, for any other number Excel considers it TRUE. If this helps, please click the Yes button Cheers, Shane Devenshire "Darts via OfficeKB.com" wrote: In cell b14 this is my formula - if these cells are blank i want the return to be blank it is giving me a return of 0 =if(sum(b4:B13),"",sum(b4:B13)) -- Message posted via http://www.officekb.com |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Try =IF(SUM(B4:B13),SUM(B4:B13),"") This works because if SUM(B4:B13) returns 0 Excel considers it FALSE, for any other number Excel considers it TRUE. If this helps, please click the Yes button Cheers, Shane Devenshire I've never come across that one before, works great! |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just a quick thanks for that explanation. I was reading these thinking that
the first parameter doesn't return a logical value. Turns out I was wrong. "Shane Devenshire" wrote: Hi, Try =IF(SUM(B4:B13),SUM(B4:B13),"") This works because if SUM(B4:B13) returns 0 Excel considers it FALSE, for any other number Excel considers it TRUE. If this helps, please click the Yes button Cheers, Shane Devenshire "Darts via OfficeKB.com" wrote: In cell b14 this is my formula - if these cells are blank i want the return to be blank it is giving me a return of 0 =if(sum(b4:B13),"",sum(b4:B13)) -- Message posted via http://www.officekb.com |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try =IF(SUM(B4:B13),SUM(B4:B13),"")
I've never come across that one before, works great! .... unless, of course, there are numbers in B4:B13 but the sum happens to be zero by coincidence. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try =IF(SUM(B4:B13),SUM(B4:B13),"")
I've never come across that one before, works great! .... unless, of course, there are numbers in B4:B13 but the sum happens to be zero by coincidence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return value of a non blank cell | Excel Discussion (Misc queries) | |||
If cell blank return a blank | Excel Worksheet Functions | |||
Return a value to a cell that is blank | Excel Discussion (Misc queries) | |||
return a blank cell | Excel Worksheet Functions | |||
return zero from a blank cell | Excel Worksheet Functions |