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?
|