View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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