In adding a single column, it's always out 1 cent, why?

C

Charly0202

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?
 
T

tim m

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?
 
B

Bob I

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numaric to Inword in excel by VB 1
Help with calculation 2
Sum totals - Help 1
out 2 cents - auto rounding? 7
Can't save my Office documents (after computer rebuild and reauthorization) 0
VBA word change keys 0
How do I convert numbers to written out text ex. 25 = Twenty Five 2
Rounding to the nearest cent...currency values 3

Top