User Profile
cdnhermit
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 =IF(XEV782=XEQ782;0;"error") One of the amount of 4.76 is transformed into 4.76000000000002 and produce an error. 4.760000000000000000000000000000 149.05 0.00 (134.29 ) (10.00 ) 4.76000000000002 error How to fix this, because it does that on many of my cells. I manually type the info and really only type 4.76 in the cell. Thanks773Views0likes5Comments
Groups
Recent Blog Articles
No content to show