| 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. |
| 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 | |||
Threaded Mode
