Simple formulas seem to round off unvoluntary in a very strange wa

  • Thread starter Thread starter Kajsa
  • Start date Start date
K

Kajsa

It seems like it, and I dont´know what to do. Cell referenser picking upp ev
A1 x B3= return valuser that aren´t "correct" as far as I understand.

it has something ti do with
1 * 28 returns 27,73
28 * 294,24 returns 8 160 ,16 (shoud be 8 238) This seems to appear randomly
within the worksheet, most formulas are correct.

Thank you för your advice!
 
Kajsa

I think that your figures have been formatted to two decimal places and not
rounded to two decimal places.

27.73300707*294.24 = 8160.16

The 27.73 should have been Rounded off to two decimal places using
ROUND(number1*number2,2)
Assuming that number1 is in A1 and number2 is in A2 the formula should be:

=ROUND(A1*A2,2)

HTH
Peter
 
Hi Kajsa

Your problem is consistent, and it's a rounding problem.

I bet that 28 is a calculated result, and that the cell is formatted
to show no decimals.

If the resulting cells if formatted to show 2 decimals, 1*27,733=27,33
and 27,733*294,24=8160,16...

Hope this helps.
....
Per
 
Back
Top