View Single Post
  #1   Report Post  
Raj
 
Posts: n/a
Default significant digits for decimals

If I have a number 0.0246589
and would like to get the 3 significant digits, what would be the function
to use?
The function (=round("cell"3-LEN(INT("cell")))) works for numbers above zero.

Thanks in advance