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   10x = b   Then   Log10(b) = x

Syntax of LOG10 Function in Excel

LOG10(number)

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

LOG10 function in Excel 1

  • 102 = 100, therefore Log10100=2
  • 103 = 1000, therefore Log101000=3

So the result will be

Results

LOG10 function in Excel 2

previous-small log 10 function in excel                                                                                                                next_small log 10 function in Excel