=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))
Rounding Significant Figures in Excel
Use the following formula to round a value to a certain number of sigfigs:
Subscribe to:
Post Comments (Atom)
Posts
1 comments:
How is this different from
=ROUND(value,sigfigs-1)
I am trying to understand the need for using log and such, because I tried this for negative values and negative sigfigs.
Post a Comment