Wrong result on dividing 2 values

K

Kyle

On Sheet 1, I have a cell E9 with a value is calculated by linking to a
value in Sheet2. The formular in cell E9, Sheet 1 is look like this
=('Worksheet2'!H13*0.1). The value in Cell H13 sheet 2 is $289.79 multiply
by 10%. The formular gives me a correct result in Cell E9, Sheet 1 which is
$28.98.

I then have another cell F9 in sheet 1 with a value of $14.238065 (6 decimal
point).
Next to the cell is G9. Cell G9 contains a formula to divide E9/F9
($28.98/$14.238065) should give me a result of 2.035389 but instead the
result in Cell G9 is 2.035331 (which is wrong).

Can anyone know what is causing the wrong result.

Thanks in advance for the reply.
 
T

Toppers

Kyle,
The result in E9 is only DISPLAYED as 28.98 but internally it is
28.979 which when divided by F9 gives the result you get (2.035319 on my
calculation).

If want to have E9 rounded to 2 decimal places then set E9 to
=ROUND(Sheet2!H13*0.1,2).

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top