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
2 Replies
Tiny rounding errors are unavoidable; they are a consequence of the way Excel processes numbers.
Since your numbers are currency values, simply round the result of your formulas to 2 decimal places:
=ROUND(SUM(C13:H13), 2)
- Hello @ Ross_hch
Could you try these suggestions here:
https://support.microsoft.com/en-us/office/set-rounding-precision-e5d707e3-07a8-4df2-810c-218c531eb06a
