Should not return error unless there are text values in those cells. Try

=IF(ISERROR((B8+C8)*G8),"",(B8+C8)*G8)

--
Jacob


"datub" wrote:

My formula is =SUM(B8:C8)*G8 where either B8 or C8 will always =0. How do I
not get this value" #VALUE!" when the cells are not in use?