Excel not calculating right

[dksaluki]

Surely it's user error, but it honestly seems like Excel is not calculating 2 numbers correctly. At work, we have office 2010 where it is not calc'ing correctly; at home I have 2007 and it's fine, but anyway, here's my situation:

Cell A1: 0.003529
Cell B1: 0.48

If i put in Cell C1: "=B1/A1" i get a value of 136.000000 But that's not correct, it should be 136.01587... But if in Cell C1 i put "=0.48/.003529" then i get 136.01587...which is correct.

Why does using cell references in my formula give me the incorrect value?

 

[circledchicken]

Hi,

I don't think it should. You've probably already tried it but I'll mention it just incase:

• Are you sure one of the values e.g. B1 is not 0.48 but 0.479943999999999 - with the cell formatted to only show 2 d.p.?
• You don't have the Precision as displayed option ticked (although I don't think this would have an impact here)

 

[Soemesh]

Hi Saluki,

I have tried in Excel 2007 and 2010 and I found it is calculating correctly. Can you make sure you are not applying any rounding off this value to 1 decimal places, 136.01587 will become 136.0. When I applied the following formula I got the same values as yours (136.0).

Here is the formula that you can verify it in Cell C1, =ROUND((B1/A1),1).

I Hope this clarify your doubt.

Kind Regards
Soemesh.