=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:
Posts (Atom)
=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))