This will be very helpful. I still need Excel to be able to count the number
of significant digits in a measurement.
For instance:
.000340 has 3 significant digits. The leading zeros are place holders.
34,000 has 2 significant figures. The trailing zeros are place holders.


"Jerry W. Lewis" wrote:

About 10 years ago I posted the formula
=ROUND(A1, A2 - 1 - INT(LOG10(ABS(A1))))
to round A1 to A2 significant figures.

It originally looked as though you were asking if there was a way for Excel
to determine A2 by formula instead of by human input--that would be a much
more difficult question.

Jerry

"bgarey" wrote:

This is all correct. But is there away to get Excel to round to the correct
place value.
I know the TI-83 calculators have an application that can round to correct
significant figures. I have no idea how to do this.