=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


"T. Valko" wrote in message
...
Try this:

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


--
Biff
Microsoft Excel MVP


"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:8db1daec70c65@uwe...
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