Tools, Options, Choose Calculation Tab, Adjust Maximum Difference and Check Precision as Displayed.
Be aware however that in this case Excel may not be able to reach the goal exactly.
If my assumption (Excel) is correct, you better post your question in the Microsoft Office Forum _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.