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