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

It sounds like you are relying on Excel formatting to do the
rounding. There are two simple solutions:

1. Explicitly use the ROUND() function in your formulas, rather
than depend on formatting to do the rounding. For example,
=ROUND(A1/A2, 2). Or ....

2. Set the option Tools Options Calculation Precision as
displayed. The downside of this option is that it affects the
calculations of all cells in the spreadsheet. That may or may
not be what you want.