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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells Rounding up but shouldn't be
Well, it's mid afternoon here ...
Check on the values in cells D3 to D6 by increasing the number of decimal places shown in the cells - you may find you actually have: Cell D3= $879.564918 Cell D4=$56000.098128 Cell D5= $4173.174968 Cell D6= $0.000000 So what happens when you add them now? Then round that to 2 dp. I think you will get $61052.84 Hope this helps. Pete "myssieh" wrote in message ... 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 |
Reply |
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 |