First, which is correct?

If you have, say:

C1: =ROUND(A$1*B1,2)
C2: =ROUND(A$1*B2,2)
....

then

C11: =SUM(C1:C10)

will give you the "correct" sum of the results in C1:C10.

If you're looking for something else, you'll need to specify how XL
should determine what's correct. See

http://www.mcgimpsey.com/excel/pennyoff.html





In article ,
G-man wrote:

I am using the round function round(A$1*B1, 2) for B1 to B10.
sum(B1:B10)*A1 does not equal the sum of round(A$1*B1to 10, 2)
It is off about $0.03. Is there a function that will round up or down to get
the correct total?