Empty cells won't cause a #VALUE error with this formula. You should only get
a #VALUE error if any of the cells (B8, C8, or G8) has a formula that
evaluates to #VALUE, or if G8 contains text (a non-numerical value).

Hope this helps,

Hutch

"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?