rounding

M

M. Johnson

how can you make excel CORRECTLY round off numbers? For example, I'm
multiplying currencies by a percentage, but it keeps giving me a number off
by $.01 from when I add up the numbers manually.
 
B

Bernard Liengme

Rounding means to take a number with a certain precision (number of
decimals, generally) and decrease the precision. If the precise numbers
totalled 100, how can you reasonably expect the imprecise ones to total
exactly 100?
 
C

CarlosAntenna

To overcome the precision problem you describe, you could try this:

tools>options>calculation>precision as displayed

I'm not sure if this is what the OP is describing, or if his difficulty is
occurring on a single number that has been rounded.
 
J

Jerry W. Lewis

You have misunderstood the issue. If A1:A3 each contain =1/3, then
SUM(A1:A3)=1, but SUM(ROUND(A1:A3,2)) is 0.99, as is SUM(A1:A3) with
pricision as displayed.

Jerry
 
Top