On Fri, 27 Oct 2006 07:18:02 -0700, thaenn
wrote:

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!

The Precision as Displayed will affect all sheets in the open workbook and will
cause all cells to permanently lose accuracy.

This may or may not be OK depending on your requirements.

But if, for example, you have a cell on some other worksheet only showing 1
decimal place when you need it to show 3 or 4, and you select precision as
displayed, you have permanently lost that precision. If, in addition, that
value is a precedent of cells on other worksheets, you may wind up with less
precision than you expect.

On the other hand, using the ROUND function requires more work, but it will
only apply to the cells to which you apply it. Only those cells, and their
dependents, will be affected by the decreased precision.


--ron