I have 2 laptops both the same brand, with the same version of Windows 8.1 Professional and with the same updates on both machines. And Office 2013 SBE installed on each, both machines are running the same file and does a calculation of the formulas and comes back with the different results. One laptop does the correct calculations, but the other one comes back with completely values. I also see this happening on multiple other machines where the calculations are completely wrong. Some machines that does the incorrect calculations I pick up you can even change the slider in the workbook to change values, I have also tried to uninstall and re-install Office 2013, I have also tried reading up elsewhere about a issue regarding a software update that broke calculations in EXCEL, but when I tried to run the FIX-IT i get that it's not supported for this system.

Hi,

Do you mind telling us which formula were you using? According to your description, the issue may be caused by the calculate precision. We may set the different precision with different pcs. When a formula performs calculations, Excel usually uses the values stored in cells referenced by the formula. For example, if two cells each contain the value 10.005 and the cells are formatted to display values in currency format, the value $10.01 is displayed in each cell. If you add the two cells together, the result is $20.01 because Excel adds the stored values 10.005 and 10.005, not the displayed values.

Please try to check the "Set precision as displayed" option to test. (File>Option>Advanced>When calculating this workbook)

If this issue still exists, please try to share us the sample data/formula, I'd like to test it.

Reference:

https://support.office.com/en-us/article/Change-formula-recalculation-iteration-or-precision-73a772d5-6224-407c-8029-60a47488b6aa

Regards,

George Zhao
TechNet Community Support