How to Use LOG10 in Google Sheets in 2020?

LOG10Returns the the logarithm of a number, base 10.

Sample Usage

LOG10(100)

LOG10(A2)

Syntax

LOG10(value)

value – The value for which to calculate the logarithm, base 10.

value must be positive.

Notes

Google Sheets does not support complex or imaginary values.

LOG10 is equivalent to LOG given base of 10.

See Also

SQRTPI: Returns the positive square root of the product of Pi and the given positive number.

SQRT: Returns the positive square root of a positive number.

POWER: Returns a number raised to a power.

LOG: Returns the the logarithm of a number given a base.

LN: Returns the the logarithm of a number, base e (Euler’s number).

GAMMALN: Returns the the logarithm of a specified Gamma function, base e (Euler’s number).

EXP: Returns Euler’s number, e (~2.718) raised to a power.

Examples