How to use the Excel LOG10 function

Summary

The Excel LOG10 function returns the base 10 logarithm of a number. For example, LOG10(100) returns 2, and LOG10(1000) returns 3.

Purpose

Get the base-10 logarithm of a number

Return value

The logarithm

Syntax

=LOG10 (number)

Arguments

Version

Usage notes

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

Related functions

The Excel LOG function returns the logarithm of a given number, using a supplied base. The base argument defaults to 10 if not supplied.

The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation.

Exceljet