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
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)