Calculations and significant digits
 

Niklas,

Round(0.012345, 4) returns 0.0123.

HTH,
Nikos

"Niklas" wrote in message
...
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