On Nov 25, 11:14*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
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.