# LOG

The `LOG` function in Google Sheets returns the logarithm of a given number to a specified base. This function is commonly used in mathematical and financial calculations.

## Usage

Use the `LOG` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

Parameters:
1. value (required):
The positive real number for which to calculate the logarithm.
2. base (optional):
The optional base of the logarithm. If not provided, the natural logarithm (base e) is used.

## Examples

Here are a few example use cases that explain how to use the `LOG` formula in Google Sheets.

### Calculate the logarithm of a number to a specified base

The `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

The `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.

## Common Mistakes

`LOG` not working? Here are some common mistakes people make when using the `LOG` Google 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:

• `LN`

The `LN` formula 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.

• `LOG10`

The `LOG10` function returns the base 10 logarithm of a given number. It is commonly used in mathematical and scientific calculations.

• `EXP`

The `EXP` function returns the result of e raised to the power of a given exponent. This function is commonly used in mathematical and scientific calculations.

• `POWER`

The `POWER` formula 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.