Purpose
Get the base-10 logarithm of a number
Return value
The logarithm
Syntax
=LOG10(number)- number - Number for which you want the logarithm.
How to use
The LOG function allows you to get the base 10 logarithm of a positive number. For example:
=LOG10(100) // returns 2
=LOG10(1000) // returns 3
=LOG10(0.1) // returns -1
LOG10 function examples
Round a number to n significant digits
This can be an intimidating formula if you don't have a good background in math, but let's work through it step-by-step. First, when you have a formula like this where one function (in this case ROUND) wraps around all others, it's often helpful to work from the outside in. So, at the core, this...
Related functions
LOG Function
The Excel LOG function returns the logarithm of a given number, using a supplied base. The base argument defaults to 10 if not supplied.
POWER Function
The Excel POWER function returns a number raised to a given power. The POWER function is an alternative to the exponent operator (^).
