Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: LOG10 function

Round a number to n significant digits in Excel

This tutorials shows how to Round a number to n significant digits in Excel. If you need to round a number to a given (variable) number of specified digits or figures, you can do so with an elegant formula that uses the ROUND and LOG10 functions. Formula =ROUND(number,digits-(1+INT(LOG10(ABS(number))))) Explanation In the example shown, the formula in D6 is as follows:…