Problem After Inserting Cell Formula

[Rick]

I have a spreadsheet where I'm using G1 as $Amt, H1 at 20% less of G1,
=sum(G1*0.2). In most cases after adding the formula the cell shows 0.00,
but in some cells it shows #VALUE!. This would not be a problem except I am
also doing a sum total of each column. The $ amount total at the bottom of
the column converts to #VALUE! because it appears in several places, say
G3-G54. I tried clearing the cell by using the "clear segment" function and
adding the formula again, but that didn't help. How do I overcome this?
Thanks, Rick

 

[Gord Dibben]

First of all you don't need the SUM function.

=G1*0.2 is sufficient.

Secondly G1*0.2 is not 20% less than G1

Third, the #VALUE! error could indicate that G1 is text, not numeric.


Gord Dibben MS Excel MVP