Forum Discussion
Excel's incorrect calculation
Hi,
Excel is calculating with full values.
you want to calculate with 22.18, but the value in the cell is 22.175 I guess. If you use round(22.175,2) --> 22.18 you excel will calculate with this value...
dennisboyko
This seems about right, however plugging it (Round) manually every time will be time consuming and it's not working across the board i.e., it works in some sells and it changes value in another!.
Will reinstalling Excel resolve this issue although it's evident the issue relates to formatting and decimals?
zink1989 Not need to reinstall. Perhaps the picture below helps.
I'm having a similar issue to the one described above, but in my case the numbers only have one decimal point each as they have been manually input by me (just, freshly, to check this out) - the difference should be just -0.4, but if you go to a number of decimals...
That's different. Google for "floating point errors" and read all about it. When you notice that and obviously correct number doesn't seem to be what it is, look for the 15th decimal to be sure. Then use ROUND to fix the problem.
Thanks. This was fantastic.
Thanks a lot Riny_van_Eekelen, i have also found a new method as follows:
In the excel file, go to File, Options, Advanced, scroll down to "when calculating this workbook" and select (tick) "Set Precision as Displayed". This will ultimately resolve the issue related to decimals and super accurate calculations.
Kindest regards,
Z
