Numbers calculation wrong

I think, as SGIII said, this is going to be something to do with rounding.

It appears that you are looking for it to be 13,500 * 49.60 = 669,600

I note that 13,500 * 49.59787... = 669,571.28

49.59787... when displayed with only two decimals will show as 49.60 but the value in the cell is still 49.59787....

I am thinking that the 49.60 shown in your table is the result of a formula and you are displaying it rounded to two decimal places. Use the ROUND function if you want it actually rounded to two decimal places.

=ROUND(your_formula, 2)

1,165,550/23,500 = 49.59787

How to proceed depends on what results you want/need to have. If the result of your first formula is 49.59787 then 669,571.28 is the correct result for the next formula even though it looks wrong. But if you want to be able to pick up a calculator and multiply the numbers you see displayed in the cells (49.60 x 13,500) then 669,600 is the correct answer.

You did not show the column letters and row numbers so I will be guessing at the formula but, if you want the results rounded to 2 decimal places every time,

cell D12 =ROUND(F11/B11, 2)

That should get you a value of 49.60

cell F12 =ROUND(B12*D12,2)

That should get you a value of 669,600

Here is the hazard/downside of doing that, using an example:

• I have two formulas, one is =1/8 and the other =7/8. The results are 0.125 and 0.875 but I show them rounded to two decimals so they look like 0.13 and 0.88. Added together in a third cell they equal 1.00, but if I picked up my calculator and added the two numbers I see, I would get 1.10
• I have two formulas, one is =ROUND(1/8,2) and the other is =ROUND(7/8,2). The results are 0.13 and 0.88. Added together in a third cell they equal 1.10. But that is not 1/8 + 7/8.

Which is right? That is a decision for you to make.

Tough to guess the specific problem because you don't show formulas or what you think the answer should be.

However, in general, keep in mind that what is displayed in a cell is not always the same as the actual value in a cell. The displayed values in your screenshot, for example, go to only two decimal places, whereas the actual values in the cells may have additional decimal places. Go to the Data Format section in the Cell tab of the right pane and vary the Decimals: to see if this is the case.

If you want to sum values that have only two decimal places then you need to use =ROUND(<the cell address or formula>,2) and sum those results.

SG

My "calculator" was wrong in my example. 0.88+0.13 = 1.01, not 1.10.