I know this post has been here awhile, but I just came across it and thought
I should comment.

This is a great function for finding the significant figures. However, this
formula needs some modification and a snippet of code if it is to be used in
VBA. This is due to the fact that in VBA log() and ln() are one in the same
and considered to be the natural log. Here's I used this function in my code:

....
For Each c In Range_B
c.Value = Round(c.Value, 5 - Int(Log10(c.Value)))
Next

And add the following:

Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function


Note: In this example I was using 5 sig figs.

Hope this is helpful
Mike

"Harald Staff" wrote:

Hi Niklas

Excel has no function for this (and I've always wondered why), but try this:

=ROUND(A1,2-INT(LOG(ABS(A1))))

The 2 is "significant digits minus 1", change to fit your needs or change it
to a cell variable.

HTH. best wishes Harald

"Niklas" skrev i melding
...
Hi
Are their any worksheet function I can use to convert a value to the
desiered significant values? At the moment I have created a UDF doing
this,
but I prefer to use worksheet function.

Some examples
Value Significant digits New value
-0.001 3 -0.001
1.99999999 3 2.00
2.00000001 3 2.00
0.012345 3 0.0123
0.00010 3 0.00010

Regards
/Niklas