LOG

Formulas / LOG
Calculate the logarithm of a number.
=LOG(number, [base])
  • number - required, positive real number
  • base - [OPTIONAL] base of the logarithm used in the function, defaults to 10

Examples

  • =LOG(16, 2)

    The LOG function is used to find the logarithm of a number with a given base. For example, this returns 4 because 16 is the number and 2 is the base. This means that 2 to the power of 4 is equal to 16.

  • =LOG(100)

    If no base is specified, the LOG function assumes that the base is 10. For example, this returns 2 because 10 to the power of 2 is equal to 100.

  • =LOG(100,10)

    The LOG function can also be used to find the logarithm of a number with a specific base. For example, this returns 2 because 10 to the power of 2 is equal to 100.


Summary

The LOG function takes two arguments, a number (required) and a base (optional). It is used to calculate the logarithm of the number with the given base.

  • The LOG function returns the logarithm of a number, with base 10 as the default unless specified.
  • The arguments for the LOG function are number and base. The number argument should be a positive real number.
  • The base argument is optional, and will change the base of the logarithm from 10 to whatever is specified.

Frequently Asked Questions

What is the LOG function?
The LOG function calculates the logarithm of a number.
What arguments does the LOG function take?
The LOG function takes two arguments:
  • Number (required)
  • Base (optional)
What is the base argument?
The base argument is the base of the logarithm.
How do I use the LOG function?
The LOG function is used by entering in the number for which you would like to calculate the logarithm and then optionally entering a base. For example, the LOG function could be used as follows:
  • LOG(x) = logarithm of x
  • LOG(x, b) = logarithm of x with base b

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