rounding

[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.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/rounding.htm

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/pennyoff.html

 

[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?

 

[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.

 

[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