Jan 18 2021 02:35 AM
Hi All,
So as easy as 1.85 x 100 may seem, my excel keeps on returning a value of 185.49.
In another case, 22.18 x 3108 is returning 68920.52 whereas it should be 68935.44.
So far I have tried to resolve by erasing all formatting, adjusting decimals, formatting into "Numbers" but the issue still exists!
Please let me know if there is any way to resolve this calculation problem in excell!!
Jan 18 2021 02:44 AM
Jan 18 2021 02:53 AM
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
Jan 18 2021 04:35 AM
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?
Jan 18 2021 04:50 AM
@zink1989 Not need to reinstall. Perhaps the picture below helps.
Jan 18 2021 05:32 AM
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
Sep 17 2024 10:23 PM
thank you so much for the tip, it solved our exel multiplication problem