Re: rounding error

Make sure your formula has is "=round(mile*rate),2)" For total use "sumproduct(FROM:TO) Understand your existing total is more correct.       Miileage 0.535000 Error 7.000000 3.7450 3.75 -0.0050 7.000000 3.7450 3.75 -0.0050 7.000000 3.7450 3.75 -0.0050 7.000000 3.7450 3.75 -0.0050 7.000000 3.7450 3.75 -0.0050 18.7250 18.75 -0.0250 ... View more