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?

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?

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?

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?