Significant Figure Rounding in Excel

A user developing an Excel final report template with calculations asked:

“Is there a way to round columns to 2 significant figures?”

Yes, you can round to any number of significant digits in Excel with this generic formula:

=ROUND(number,digits- (1+INT(LOG10(ABS(number)))))

Where ‘number’ is the value to round and ‘digits’ is the number of significant digits. To round the value in cell B5 to two significant figures, for example, use this formula in another cell:

=ROUND(B5,2-(1+INT(LOG10(ABS(B5)))))