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


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


Example of LOG10 Function in Excel


LOG10 function in Excel 1

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

So the result will be


LOG10 function in Excel 2

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

DataScience Made Simple