Return blank not 0

[Darts via OfficeKB.com]

In cell h6 this is my formula however i want the return to be blank if
nothing is in these cells it now return 0 how do i write to return blank
=SUM(C6*2)+(E6*3)+(G6*1)

 

[Forgone]

In cell h6 this is my formula however i want the return to be blank if
nothing is in these cells it now return 0 how do i write to return blank
=SUM(C6*2)+(E6*3)+(G6*1)

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.

 

[T. Valko]

Try this:

=IF((C6*2)+(E6*3)+(G6*1),(C6*2)+(E6*3)+(G6*1),"")

 

[T. Valko]

=IF((C6*2)+(E6*3)+(G6*1),(C6*2)+(E6*3)+(G6*1),"")

Improvement: no need to multiply any value by 1:

=IF((C6*2)+(E6*3)+G6,(C6*2)+(E6*3)+G6,"")


--
Biff
Microsoft Excel MVP

Try this:

=IF((C6*2)+(E6*3)+(G6*1),(C6*2)+(E6*3)+(G6*1),"")

 

[Shane Devenshire]

Hi,

Since we are making improvements:

=IF(C6*2+E6*3+G6,C6*2+E6*3+G6,"")

If this helps, please click the Yes button.

Cheers,
Shane Devenshire