Excel SUM function out 0.01 in Excel for Home MAC OS 26.5.2

Question

When I use SUM function on small numbers like 3.88 it give wrong result. I try ROUND but it did not help.

What to do?

Answer 1

Hi Irina,

Use this formula to calculate in decimals, numbers in excel can be stored in binary floating‑point.

=SUMPRODUCT(ROUND(A1:A10, 2)) adjust the cells to match your work sheet

If imported (data) on to your workshop do the following to make sure that it reads as decimal
Select the range

1. Go to Data, Text to Columns

Click Finish (no changes needed)

This forces Excel to re‑parse the numbers as clean decimals.