In financial transaction applications I find this option very useful.
But be careful; it only works for cells that are explicitly formatted.
If your cell is formatted as general, but just wide enough to display "3.01" it retains its original precision, like 3.051 or
3.0149
In engineering or financial research applications it probably does more harm than it helps.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"thaenn" wrote in message ...
| Barb,
| Is there an advantage or disadvantage to using "precision as displayed" vs.
| entering "round" into the formula?
| Thanks for your help!
|
| "Barb Reinhardt" wrote:
|
| Alternatively, you could go to
|
| Tools- Options - Calculation and select PRECISION AS DISPLAYED
|
| if that's really what you want.
|
| "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?