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 ...
I have no idea why Excel would change the value if you type it in yourself. If 4.76 is the result of a formula it would be 'normal' behavior for Excel.
Since your numbers have 2 decimal places, change the formula to
=IF(ROUND(XEV782;2)=ROUND(XEQ782;2);0;"error")
or to
=IF(ROUND(XEV782-XEQ782;2)=0;0;"error")
Thank you, I used the Round() function and it solved my problem.
