Cell to return blank not 0
 

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

Cell to return blank not 0
 

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.

Cell to return blank not 0
 

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

Cell to return blank not 0
 

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

Cell to return blank not 0
 

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!

Cell to return blank not 0
 

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

Cell to return blank not 0
 

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.

Cell to return blank not 0
 

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.