LOGfunction in Google Sheets returns the logarithm of a given number to a specified base. This function is commonly used in mathematical and financial calculations.
- How to use
- Examples of using
LOGformula not working?
- Similar formulas to
LOG formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
- value (required):
The positive real number for which to calculate the logarithm.
- base (optional):
The optional base of the logarithm. If not provided, the natural logarithm (base e) is used.
ExamplesHere are a few example use cases that explain how to use the
LOGformula in Google Sheets.
Calculate the logarithm of a number to a specified base
LOG function can be used to calculate the logarithm of a given number to a specific base, such as base 10 or base 2.
Calculate the natural logarithm of a number
If the base parameter is not provided, the
LOG function returns the natural logarithm of the given number, which is often used in mathematical and scientific calculations.
Calculate the logarithmic growth rate of an investment
LOG function can be used to calculate the logarithmic growth rate of an investment over a period of time, given the initial and final values of the investment.
LOGnot working? Here are some common mistakes people make when using the
LOGGoogle Sheets Formula:
Incorrect number of arguments
The LOG formula requires two arguments: the value and the base. Make sure you are including both arguments and separating them with commas.
Base is not a positive number
The base argument in the LOG formula must be a positive number. Double-check that you are using a positive number as the base.
Value is not a positive number
The value argument in the LOG formula must be a positive number. Double-check that you are using a positive number as the value.
Using the wrong base
Make sure you are using the correct base for your calculation. If you are not sure what base to use, consult the problem you are trying to solve or look up the relevant information.
Incorrectly formatted syntax
Make sure you are using the correct syntax for the LOG formula. The formula should be written as follows: LOG(value, base)
The following functions are similar to
LOG or are often used with it in a formula:
LNformula returns the natural logarithm of a given value. The natural logarithm is the logarithm to the base e, where e is an irrational number approximately equal to 2.71828. The formula is commonly used in mathematical and scientific calculations.
LOG10function returns the base 10 logarithm of a given number. It is commonly used in mathematical and scientific calculations.
EXPfunction returns the result of e raised to the power of a given exponent. This function is commonly used in mathematical and scientific calculations.
POWERformula is a mathematical function that calculates a number raised to the power of another number. It returns the result of a base number raised to an exponent.
You can learn more about the
LOG Google Sheets function on Google Support.