The sum is still rounding up from the 3rd decimal. Also, it seems to be
doing it only when the cell reference is a formula.
Example:
cell A3 =sum(A1-A2) is $2510.63
cell A4 =sum (A3*.05) is $125.53
cell A5 =sum(A3*.07) is $ 175.74
=sum(A3+A4+A5) should equal 2811.90 but excel is calculating it at 2811.91
The larger the numbers I deal with the larger the discrepancy becomes.

I have never encountered this in excel 2003...

Thanks,
Shay
"Ashish Mathur" wrote:

Hi,

You can use the following array formula (Ctrl+Shift+Enter).

SUM(ROUND(A1:A2,2))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Shayla2008" wrote in message
...
I am using simple addition & multiplication formulas and the sum appears
to
be calculating to the 3rd decimal which is making my totals unacceptable.
My
formatting in the cells are for 2 decimal places. How can I ensure the
formula is also calculating to only the 2nd decimal place?