Thank you. We can hope that Excel will have one in the future. I will use you
soloution and hopefully the users do not complain when they lose presicion
when 0.0010 will be converted to 0.001
Regards
/Niklas

"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