| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In adding a single column, it's always out 1 cent, why?
Help! Only certain times I get an addition out by 1 cent. When I check the
column with a calculator, my numbers are right, but the Excel answer is out. Why? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In adding a single column, it's always out 1 cent, why?
Perhaps this explains it...
http://mcgimpsey.com/excel/pennyoff.html Rick "Charly0202" wrote in message ... Help! Only certain times I get an addition out by 1 cent. When I check the column with a calculator, my numbers are right, but the Excel answer is out. Why? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In adding a single column, it's always out 1 cent, why?
Most likely because Excel is rounding. In some cases if the numbers have
come from another calculation elsewhere they may be showing up as hole numbers or displaying two decimals but in fact the numbers might have more decimal places, thus when they are added up they may round in a fashion that ends up being out by a penny. I believe you can use the ROUND function to aleviated this. Are the numbers you are summing manually entered or do they come from a calcuation elsehwere on the sheet? "Charly0202" wrote: Help! Only certain times I get an addition out by 1 cent. When I check the column with a calculator, my numbers are right, but the Excel answer is out. Why? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In adding a single column, it's always out 1 cent, why?
Most likely because you are not viewing all the digits of "your number".
Enter your numbers with only 2 decimal places and you will see the expected answer. Charly0202 wrote: Help! Only certain times I get an addition out by 1 cent. When I check the column with a calculator, my numbers are right, but the Excel answer is out. Why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding text in a single column | Excel Worksheet Functions | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| Adding Value within a single cell... | Excel Worksheet Functions | |||
Linear Mode
