rounding

  • Thread starter Thread starter M. Johnson
  • Start date Start date
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.
 
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?
 
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.
 
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
 
Back
Top