LOG10
Formulas / LOG10Calculate 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?
What is the argument for the LOG10 function?
Is the argument required?
What type of number can be used for the argument?
