Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent EXCEL from rounding the result of a calculation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent EXCEL from rounding the result of a calculation
Maybe you could use
=rounddown(yourformula,1) elusiverunner wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent EXCEL from rounding the result of a calculation
Thanks very much Dave - works a treat
"Dave Peterson" wrote: Maybe you could use =rounddown(yourformula,1) elusiverunner wrote: 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. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent EXCEL from rounding the result of a calculation
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(). -- David Biddulph "elusiverunner" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Calculation Result Display Failure | Excel Worksheet Functions | |||
HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING | New Users to Excel | |||
stop excel from rounding a result | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |