ID EN
#Math

LOG10

Excel Functions

Get the base-10 logarithm of a number

Syntax

EXCEL
=LOG10(number)

Arguments

Parameter Description
number The positive number for which you want the base-10 logarithm.

Return Value

The logarithm

Details

LOG10 returns the base-10 logarithm of a number. In simple terms, it answers the question: "10 raised to what power gives me this number?" The table below shows how LOG10 works and how it is related to raising 10 to a specific power: For numbers that aren't exact powers of 10, LOG10 will return get decimals: To use Excel's LOG10 function, just supply a number:

Examples

Example 1

To use Excel's LOG10 function, just supply a number:

EXCEL
=LOG10(1000) // returns 3
=LOG10(100) // returns 2
=LOG10(10) // returns 1
=LOG10(1) // returns 0
=LOG10(0.1) // returns -1
=LOG10(0.01) // returns -2

See Also

LOG POWER