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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrong result on dividing 2 values
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 "Kyle" wrote: 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. |
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) |