0

Why the decimal point numbers resulted by dividing two numbers in excel are not exactly the same as the answers in home calculator.

for example: In excel___ C1 : 3853093 C2 : 108,810 =C1/C2 => 35.41135921

In calculator: 3853093 ÷ 108810 = 35.411203

if I take and make further calculations by the result from excel with 6 decimal point, there will be a difference in final result according to the actual value.

Please Help me...Sorry for my bad english!

Kaung Myat Paing
  • 25
  • 1
  • 7
  • 1
    Possible duplicate of [Why does Excel not round according to 8-byte IEEE 754](https://stackoverflow.com/questions/36452194/why-does-excel-not-round-according-to-8-byte-ieee-754) – dwirony Mar 14 '19 at 17:38
  • In Excel I get 35.41120301 - did you make a mistake? – Tim Williams Mar 14 '19 at 17:46

1 Answers1

0

Are you sure you entered the data correctly in Excel?

I am getting 35.411203 in both Excel and my phone's calculator.

enter image description here

CATSandCATSandCATS
  • 302
  • 4
  • 12
  • Thanks...sir.I have got the point. Actually, I needed to add Round func: to the two inputs...my excel calculated original resulted value 3853093 with some decimal points and I saw the decimal points when I double click the cell.:) – Kaung Myat Paing Mar 16 '19 at 08:00