Search code examples
excelexcel-formulaexcel-2013

excel calculation excess 1 on one file

There is a file that contains mathematical operations that are a bit complicated.

When the file is opened on my laptop the value of 500,000,000 changes to 500,000,001, an excess of 1 number.

What exactly should I do?

I use Excel 2013, using an Asus X441U

Solution

  • This is commonly a formatting problem.

    Please make sure that you are obtaining the real value of the result, not the displayed value.

    This is best done by changing the cell number formatting. I would recommend adding a helper cell or two to and use =CELL("contents",yourcellwithchangingvalue) as one test.

    Another method is to make a second result cell and wrap it in =TEXT(yourcellwithchangingvalue, "#.###") to see if that causes it to change.

    Lastly, be sure all of your formulas are using functions or addins that are available on both machines.