Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Worksheet Functions | |||
Number format | Excel Discussion (Misc queries) | |||
convert numbers to text | Excel Discussion (Misc queries) |