View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kyle Kyle is offline
external usenet poster
 
Posts: 66
Default Wrong result on dividing 2 values

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.