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
"Darts via OfficeKB.com" 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)
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1