LOG10

Formulas / LOG10
Calculate the base 10 logarithm of a number.
=LOG10(number)
  • number - required, positive real number to logarithm

Examples

  • =LOG10(100)

    The LOG10 function is used to calculate the base-10 logarithm of a positive number. The syntax for the LOG10 function is . For example, if you want to calculate the base-10 logarithm of 100, you would enter the preceding formula into a cell in Sourcetable. This will return the result of 2.

  • =LOG10(1000)

    To calculate the base-10 logarithm of 1000, you would use this formula. This will return the result of 3.

  • =LOG10(-100)

    The LOG10 function only accepts positive numbers as arguments, so entering a negative number will produce an error. For example, if you enter the above formula into a cell in Sourcetable, it will return an error.

  • =LOG10(A1)

    You can also use the LOG10 function to calculate the base-10 logarithm of a cell reference. For example, if cell A1 contains the number 100, you can enter the formula above into a cell to calculate the base-10 logarithm of the value in cell A1.


Summary

The LOG10 function is used to calculate the base 10 logarithm of a number and is helpful when working with large numbers. It can also be used to change the base of a number in a formula.

  • The LOG10 function takes a number argument as a required parameter, which can be positive or negative.
  • The LOG10 function returns the base 10 logarithm of the number.

Frequently Asked Questions

What is the LOG10 function?
The LOG10 function calculates the base-10 logarithm of a number.
What is the argument for the LOG10 function?
The argument for the LOG10 function is a number.
Is the argument required?
Yes, the argument is required.
What type of number can be used for the argument?
The argument must be a positive real number.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV