| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation issue?
Decimal fractions don't always convert easily to binary. Some fractions
like 1/3 cannot be expressed exactly in decimal. Therefore, small rounding errors creep in to some formulae, and yours is one such example. Try rounding the results of your dsum to 2 dp using ROUND( ) and see if this helps matters. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation speed issue | Excel Discussion (Misc queries) | |||
| Issue with zero/# issue!! | Excel Worksheet Functions | |||
| Vlookup Calculation Issue | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Threaded Mode
