LOG10 function in Excel

Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

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… read more »

Sidebar