| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect result for simple SUM formula
Hello,
Does anyone know why Excel sometimes give an incorrect result when adding the contents of cells? It may only be 1p out but even if I increase the decimal places it doesn't seem to make sense as the decimal places are showing a lesser number than the +1p error. e.g. =SUM(D12:D22) result 13.75 (should be 13.76) increase decimal places result becomes 13.74643 -- Cheers, V |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I correct an incorrect total from a simple formula? | Excel Discussion (Misc queries) | |||
| Formula looks right but shows incorrect result | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| formula result incorrect | Excel Discussion (Misc queries) | |||
| ACCRINT formula gives incorrect result | Excel Worksheet Functions | |||
Threaded Mode
