CORRECTING ERROR IN A SUM FORMULA

B

BBGSIS

MY SUM OF A COLUMN OF CELLS IS OFF BY A FEW CENTS (EACH CELL CONSISTS OF A
CALULATION). I HAVE TO MANUALLY ADD THE COLUMN TO VERIFY IF IT IS OFF OR NOT
AND IT ALWAYS IS BY A FEW CENTS.
 
B

Bob Phillips

Probably due to the figures showing rounded, but the real values being not
rounded. Try rounding all the amounts

=ROUND(A1,2)

or SUM the result rounded

=SUM(ROUND(D1:D9,2))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top