Ron,
Is there an advantage or disadvantage to using "round" in the formula vs.
checking "precision as displayed" that was also suggested?
Thanks for your help!

"Ron Rosenfeld" wrote:

On Fri, 27 Oct 2006 06:24:01 -0700, 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?

Your formula is not using the values you think it is.

If you look at the actual values in the precedent cells, you will see that they
are not exactly 15,000 or 3.01.

If you want to get an answer based on the rounded values in those cells, then
you must explicitly round them.

e.g. =ROUND(D25,2)/ROUND(K24,2)


--ron