Rounding numbers then doing a sum of those numbers produces incorrect result.
 

I have a row of numbers that gets calculated from two other rows. I
formatted this row as a number with two decimal places. I then take that row
of numbers and do a sum on it but it produces a result that is one cent off
the actual total (because I think it is adding the whole number and not the
rounded format that I chose). Is there anyway to fix this?

Thanks

Rounding numbers then doing a sum of those numbers produces incorrect result.
 

Hi,
Formatting does not change the underlying value. It only changes the
appearance.
Toolsoptioncalculation workbook options, check "precision as displayed".


--

John

johnf202 at hotmail dot com


"GzusRox" wrote in message
...
I have a row of numbers that gets calculated from two other rows. I
formatted this row as a number with two decimal places. I then take that
row
of numbers and do a sum on it but it produces a result that is one cent
off
the actual total (because I think it is adding the whole number and not
the
rounded format that I chose). Is there anyway to fix this?

Thanks

Rounding numbers then doing a sum of those numbers produces incorrect result.
 

You will get a more accurate sum if you don't round, e.g.
1/3 + 1/3 + 1/3 = 1
vs.
.33 + .33 + .33 = 0.99

Jerry

GzusRox wrote:

I have a row of numbers that gets calculated from two other rows. I
formatted this row as a number with two decimal places. I then take that row
of numbers and do a sum on it but it produces a result that is one cent off
the actual total (because I think it is adding the whole number and not the
rounded format that I chose). Is there anyway to fix this?

Thanks