| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Going Crazy, excel can't subtract!
Have the cells formatted to Number (15 dec points)
A1: 159.810000000000000 A2: 159.800000000000000 A3: =A1-A2 A3 returns: 0.009999999999991 Should it not retun 0.010000000000000 What's going on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| what excel formula will perform a running subtract from one value | Excel Discussion (Misc queries) | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Threaded Mode
