View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default ERRORS IN A DIVISON FORMULA

If you change the format of K24 to General and make the column wide enough, you'll probably notice that its value is 3.013179394.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"thaenn" wrote in message ...
|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?