LOG10 Function in Excel – Calculate Common logarithm in Excel

LOG10 function in Excel calculates the logarithm of a given number, to the base 10.

If   10^x = b   Then   Log₁₀(b) = x

Syntax of LOG10 Function in Excel

Where number is the Positive real number that you want to calculate the logarithm to the base 10.

 

Example of LOG10 Function in Excel

Formula

• 10² = 100, therefore Log₁₀100=2
• 10³ = 1000, therefore Log₁₀1000=3

So the result will be

Results