Decimal values - is this normal?

[Jim Gordon]

Hi

Please have a look at this workbook. There are oddities in the sum in cell B12107. I was expecting that the sum would have values only in 2 decimal places.

Likewise, in column B, I was expecting values in only the first 2 decimal places.

Is this the expected behavior? I get the same results in OpenOffice.

 

[Joe4]

I cannot view your sheet from my current location, but I suspect this may be the issue:
https://support.microsoft.com/en-us...ithmetic-may-give-inaccurate-results-in-excel

If it is, you can get around it by embedding your SUM in a ROUND function.

 

[Fluff]

As Joe has pointed out it's due to floating point, in col A
In col B you are seeing the odd results because Excel only shows numbers to 15 significant places.
If you look at B12103 the extra 2 is the 15th digit, so it will show in col B but not in A as that has extra digits at the front.

 

[Jim Gordon]

Thanks for the explanations!

 

[Fluff]

Glad we could help & thanks for the feedback