| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells Rounding up but shouldn't be
Good Morning!!
I am running Excel 2003.. I have a group of cells that are being added together and excel is rounding them up by .01... Cell D3=$879.56 Cell D4=56000.10 Cell D5=$4173.17 Cell D6=$0.00 Cell D7 is a sum of the above and it shows $61052.84. When you manually calculate these fields it shows $61052.83. There is no formula on the cell that tells it to do this... What could be causing this and/or how can I prevent it? Thanks in advance!! Myssie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding and comparing cells | Excel Discussion (Misc queries) | |||
| Addition of cells involving rounding | Excel Discussion (Misc queries) | |||
| Rounding Up in Cells With Formulas | Excel Worksheet Functions | |||
| rounding down to positive when adding cells | Excel Worksheet Functions | |||
| How to apply rounding across a range of cells with other formulae | Excel Worksheet Functions | |||
Threaded Mode
