CORRECTING ERROR IN A SUM FORMULA

[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.

[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)

"BBGSIS" <BBGSIS@discussions.microsoft.com> wrote in message
news:CDF48BB6-CD7A-4AC0-8A0A-42BC37BCBD18@microsoft.com...
> 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.

[Jerry W. Lewis]

Bob is probably correct. If you need more information, consult
http://www.mcgimpsey.com/excel/pennyoff.html

Jerry

"Bob Phillips" wrote:

> 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)
>
> "BBGSIS" <BBGSIS@discussions.microsoft.com> wrote in message
> news:CDF48BB6-CD7A-4AC0-8A0A-42BC37BCBD18@microsoft.com...
> > 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.
>
>
>