ERRORS IN A DIVISON FORMULA
thaenn wrote:
i have a formula in "cell K25" that is dividing 15,000 (Cell D25) by 3.01
(Cell K24) and I am getting a result of 4,978.13.
This is close to the correct answer, but not exact. The correct answer
should be 4,983.39.
The formula is written as follows: =D25/K24
Any Suggestions?
Looks like the actual value in the K24 cell is 3.009999 but it is
formated as Number with 2 decimal places. If you reformat K24 to
general or increase it number of decimal places to 6 then you will more
than likely see its value displayed as 3.00999, not 3.010000.
Ken Johnson
|