Forum Discussion
cell's value in error in Excel
I have Excel 2016 version 2306 build 16529 20182. My excel converts 4.76 into 4.760000000000020000 and gives me an error I am trying this: 4.76 149.05 0.00 (134.29 ) (10.00 ) 4.76 ...
Thank you for your explanations.
Be very careful how you use ROUND. The logic of "I know the two amounts are essentially the same, so by ignoring fractions of a cent, they will be exactly the same" is sound and the test will succeed.
The catch comes if, later in the calculation, you multiply by a million. Rounding will have removed all 10ths of a cent as insignificant. However, once you have multiplied by a million the discarded tenths are now $1000s. Rounding can create as many problems as it solves!