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?