Excel's incorrect calculation

Question

Hi All,&nbsp;So as easy as 1.85 x 100 may seem, my excel keeps on returning a value of 185.49.&nbsp;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!!

riny_van_eekelen · Answer

zink1989&nbsp;Not need to reinstall. Perhaps the picture below helps.

schwartauextra · Answer

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) --&gt; 22.18 you excel will calculate with this value...&nbsp;dennisboyko&nbsp;

riny_van_eekelen · Answer

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 &nbsp;problem.

dennisboyko · Answer

no experience how do I average a column of numbers??

zink1989 · Answer

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?

SchwartauExtra

Forum Discussion

Excel's incorrect calculation

10 Replies

Resources