Problem in 1 File, I have divided and later multiplied same result with the denominator and it gives different numberator.
But in another file it is ok:
Asked
Active
Viewed 32 times
0
Bhim Bhandari
- 11
- 2
-
maybe the calcs are set to manual on the first and you need to press F9 to calculate? – Scott Craner Sep 18 '20 at 17:31
-
Calucation is automatic, doing f9 also does not help. – Bhim Bhandari Sep 18 '20 at 17:44
-
just double check that there really is no number in C5. – Scott Craner Sep 18 '20 at 17:46
-
If i increase the precision of decimal to 10 difference becomes nil in the first file. But in second file it is ok with 2 precision – Bhim Bhandari Sep 18 '20 at 17:50
-
I have found the solution, It has to do with the excel setting, Change the following settings: File > Options > Advanced > Untick the **Set Precision as Displayed** – Bhim Bhandari Sep 18 '20 at 18:10
1 Answers
0
It has to do with the excel setting, Change the following settings:
File > Options > Advanced > Untick the Set Precision as Displayed
Bhim Bhandari
- 11
- 2