Numbers won't add correctly

Alison,
It's an interesting argument, but testing your figures we don't see the problem This is an actual Numbers table with your figures in it, and I'm sure you could duplicate it.
I suspect that there are things you aren't telling us. You may not want to complicate the discussion with details, but they are critical to getting to the explanation.
Jerry

Like (0)


Jeff Shenk Manheim, PA
Alison,
If you select the cells with the twelve numbers and adjust the format to show at least three decimal places, can you see why this might be happening?
As Jerry said, Numbers does do this sum correctly.
Jeff

Like (0)


Wayne Contello Austin, Texas

Like (0)


Yellowbox New South Wales, Australia
Hi Alison,
You said "4 lots of one number (1,167) and 8 lots of another number (933)"
Here is a spreadsheet that uses SUM
You said cashflow, so I used Currency format.
$1,167.00
$1,167.00
$1,167.00
$1,167.00
$933.00
$933.00
$933.00
$933.00
$933.00
$933.00
$933.00
$933.00
$12,132.00
The entries start in Column B and end in Column M. The formula in Column N on the right is:
=SUM(B2:M2)
Answer is $12,132.00, not "12,133 "
Could there be some rounding errors in previous formulas that produce
"4 lots of one number (1,167) and 8 lots of another number (933)" ?
Ian.

Like (0)


It's adding correctly to the 12,132 in the columns but not in the rows. This is where I'm really stumped. Decimal places are set to 0, as I'm only working with whole number through out the tables. Therefore the amount of decimal places should not matter. However, It still insists on being one up or one below in the rows.

Like (0)


You might have to post a screenshot so we know what "adding correctly to the 12,132 in the columns but not in the rows" means. Obviously there is some difference in what is being added when you do rows vs columns.
Setting the decimal places to 0 does not mean the value in the cell has nothing after the decimal. That setting is for display of the number, it does not affect the actual number.
If I have the number 123.45 in a cell and I format that cell to 0 decimal places it will look like 123 but if I use it in a formula, such as a SUM, it will use the number 123.45 in that formula.
100.4 + 100.4 + 100.4 = 301.2
if formatted with no decimal places it would look like this in your table:
100 + 100 + 100 = 301
So, if you follow the advice given previously and increase the number of decimal places to see what you really have in those cells, you might discover your problem.

Like (0)


Setting the format of the display to zero decimals only fools the eye. To set the value to zero decimal places, use either the ROUND or INT function.
Jerry

Like (0)


The numbers in all the cells of that particular row were typed in as whole numbers manually by myself. I can understand if the cels were a rounded figure then the sum total would add the original figures before rounding and round to the nearest whole figure at the end. I have created another table and it seems to be okay now so I will probably just start fresh with that one.
Thanks for your help everyone.
Alison.

Like (0)


Oh thanks very much I will try that in future.

Like (0)


That's where I'm lost for an explanation because the number in all the cells in the row were typed in as whole figures manually by me. As I said before if the figures were rounded amounts of a figure containing decimal places then I would understand it to sum up the original input values and round at the very end.

Like (0)


Wayne Contello Austin, Texas
Alison,
Please look in my profile and email me your document exhibiting the problem
Thanks,
Wayne

Like (0)


I'm curious like Wayne is. Can you post the document or email it to me. I'd like to see this anomaly.

Like (0)
