| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtracting decimals
Why is this? ...
In Excel if I subtract, for example, 1282.39 from 1282.40, and the answer cell is displayed with 14 or more decimal places, the result displays as 0.00999999999999, when in fact the correct result, obviously, is exactly 0.01. What's happening here, and how do I prevent it? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| change 5523.44 to 552344 no decimals | Excel Worksheet Functions | |||
| No decimals and leading zeroes | Excel Discussion (Misc queries) | |||
| Decimals separation by . or , | Excel Discussion (Misc queries) | |||
| Aligning decimals in Excel ... | Excel Discussion (Misc queries) | |||
Threaded Mode
