#VALUE! in cell
Perhaps you have a formula in B8 or C8 that returns "0" rather than 0.
Note the first of these is a text value and this will give you the
#VALUE error if you try to use it with arithmetic. Or, it could be
that a formula in G8 is returning a number enclosed within quotes, and
again this is a text value and will give that error.
Only you know what formulae you have, as you have not shared those
with us.
Note that you don't really need the SUM in this case - you could write
your formula as:
=(B8+C8)*G8
Hope this helps.
Pete
On Dec 19, 1:38*am, 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?
|