Prevent EXCEL from rounding the result of a calculation

  • Thread starter Thread starter elusiverunner
  • Start date Start date
E

elusiverunner

As the subject suggests I am performing a calculation to which the result is
a number with 1 decimal place. Excel keeps rounding this up and I don't want
it to. For example my calculation is giving a result of 13.96 to which I
would like an answer of 13.9 but Excel is giving the answer as 14.0, which
reduces the acuracy of other formulas that use this answer as part of their
result.
 
Maybe you could use

=rounddown(yourformula,1)

As the subject suggests I am performing a calculation to which the result is
a number with 1 decimal place. Excel keeps rounding this up and I don't want
it to. For example my calculation is giving a result of 13.96 to which I
would like an answer of 13.9 but Excel is giving the answer as 14.0, which
reduces the acuracy of other formulas that use this answer as part of their
result.
Click to expand...
 
Merely displaying a number with 1 decimal place won't cause Excel to change
the value for subsequent calculation (unless you have set the option for
"precision as displayed").
If you've used the ROUND() function, then remove it. The 14.0 is of course
*more* accurate than your suggested 13.9, but if you do want 13.9 you can
use ROUNDDOWN().
 
Back
Top