On Sat, 12 Nov 2005 09:29:02 -0800, echase
wrote:

How do I get Excel to add the rounded numbers in the cells, formated to 2
decimal places, and get the same answer that I would get if I added them on
the calculator. Excel seems to add the unrounded numbers giving an
incorrect answer, off by 1 or 2.


=SUM(ROUND(rng,2))

entered as an *array* formula (hold down <ctrl<shift while hitting <enter.
Excel will place braces {...} around the formula).


--ron