Incorrect Calculations

[meddle71]

I am using Excel 365 on Windows 11. For some reason, calculations are not work correctly for me.

On the attached image, in Cell G8 I have summed F7 x A8. That is, 0.102 x 48 = 4.896

Then in Cell H8, I have entered the sum:

=SUM(F8-G8). That is, 5.716 - 4.896 = 0.82

Why am I getting the result 5711.104 ? That is the the result for 5,716 - 4.896. Why has 5.716 been referred to as 5,716?

I have loaded the same worksheet in Excel on my Mac, and the calculations are correct. I have even used Google Sheets and get the correct calculations. I have passed my worksheet onto colleagues and they get the correct calculations. This is driving me a bit nuts.

 

[Bond00]

Is it only this sheet or an issue with your 365 install? If its only this sheet then maybe upload it and link it here so we can take a look, if it happens in other sheets for you as well then maybe uninstall and reinstall office and see if that solves the issue.
If its just this 1 calculation then check the cell format and make sure its not something odd, manually set format to Number or something and then see the result.

 

[meddle71]

Hi Bond00, thanks for the replay, but after several months trying to resolve this issue, I think I did it. See the attached image. I have some customised separators rather than the System separators. It seems to have fixed the issues.

 

[Peter_SSs]

Welcome to the MrExcel board!

Glad you figured out what the issue was.

Just one further comment in relation to the formula:
=SUM(F8-G8)
In this formula, the SUM function adds nothing. F8-G8 will calculate a single number and then SUM will sum that single number which of course results in that same single number.
=F8-G8 would be simpler and more efficient.