walkerdayle said:
As an alternative, how can I sum up the rounded values
but not the values in the cell? For example: B3 = 5.23
(but it's really 5.2345) and B4=3.23 (3.23111)
How can I add the two and get the true answer even though
B3:B4 are answers using the ROUND function.
Your first and second questions are contradictory.
What are you calling the "true answer"?
I presume you would like the sum to be 8.465561 or rounded
to 8.47 instead of 8.46, which is the sum of the rounded
values. Please confirm.
(Note that that is __not__ "summing up the rounded values
but not the values in the cell".)
Simply put: you cannot do that, at least not directly.
How big is the spreadsheet -- at least the cells that
have rounded values?
If the cells have "=ROUND(...,2)", can you simply do
one of two things, depending on which best fits your
overall needs (which are not clear):
a. Simply edit the cells and remove "=ROUND(" and ",2)".
Ideally, you only need to edit one cell, then copy
the modified formula into all similar cells. If you
want any cells to appear to be rounded to 2 decimal
places, simply change the cell format (Format > Cells
Number, and select Number and 2 Decimal Places).
b. Copy the cells with "=ROUND(...,2)", then paste them
somewhere else. Edit the copied cells as described
in #a.
Of course, we are all shooting blindly because we
cannot see your spreadsheet, and your description begs
for clarification.
A much simpler solution might be possible if, for
example, the rounded formula is simply "=ROUND(A3,2)".
In that case, you might not need to do the edits
described in #a or #b at all. All you need to do is
SUM(A3:A4) instead of SUM(B3:B4).