Forum Discussion
excel math error
formula breaks if a valve under -499 is entered (-500) in G9 the sum of the three columns should be 571.31 but it returns 571.3099999999999
Hello @ Ross_hch
Could you try these suggestions here:
https://support.microsoft.com/en-us/office/set-rounding-precision-e5d707e3-07a8-4df2-810c-218c531eb06a
Could you try these suggestions here:
https://support.microsoft.com/en-us/office/set-rounding-precision-e5d707e3-07a8-4df2-810c-218c531eb06a