D
Dan
Rounding!
Make the cells you are adding 4 or 5 decimal places, and
try manually adding all numbers with 4 or 5 decimal places.
You will get closer to the number Excel added with @sum.
Excel uses high precision internally, then displays the
number according to the format of the cel.
--Dan
Make the cells you are adding 4 or 5 decimal places, and
try manually adding all numbers with 4 or 5 decimal places.
You will get closer to the number Excel added with @sum.
Excel uses high precision internally, then displays the
number according to the format of the cel.
--Dan