Same Formulae Different Values in Different File- Problem of round off of decimal

56 Views Asked by At

Problem in 1 File, I have divided and later multiplied same result with the denominator and it gives different numberator. I have divided and later multiplied same result with the denominator and it gives different numberator

But in another file it is ok: enter image description here

1

There are 1 best solutions below

0
On

It has to do with the excel setting, Change the following settings:

File > Options > Advanced > Untick the Set Precision as Displayed