After a few hours of brain crunching, I finally figured out a fairly concise Excel function for rounding to a specific number of significant digits:

=ROUND(

For more information about this function, you can see the write-up on my site. I also included a corresponding custom Excel VBA function.

Rounding Significant Figures in Excel

Enjoy,

Jon

=ROUND(

*value*,*sigfigs*-(1+INT(LOG10(ABS(*value*)))))For more information about this function, you can see the write-up on my site. I also included a corresponding custom Excel VBA function.

Rounding Significant Figures in Excel

Enjoy,

Jon

## Comment