adding accurately in excel

A

Alice

When I used the @sum to add my total, the total is one number less that it's
supposed to be. Why is the automatic function not adding correctly?
 
S

ShaneDevenshire

Hi Alice,

Most likely Excel is adding the number correctly. Consider

3.33
3.33
3.33
-----
9.99

Now if you format these numbers, and the total to 0 decimal places you would
see
3
3
3
 

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

Excel Excel help please 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Formula or equation 3
excel adding error? 1
Adding only 2 numbers doesn't come up with correct sum 1
adding time (H:M)in two cells, I get (#VALUE!) if the total>1000 2
excel wont add columns 1
Total sum is zero when it should be adding multiple cells 2

Top