SheetFX
≡
<< Go back to all functions

LOG

The LOG function in Google Sheets returns the logarithm of a number given a base. It is a useful tool for calculating logarithms in various scenarios. Learn how to apply the LOG function with our comprehensive guide.

Function Syntax and Parameters

Syntax: LOG(value, base)

Parameters:

  • value: The number for which the logarithm needs to be calculated.
  • base: [Optional] The base of the logarithm. If not specified, the default base is 10.

Step-by-Step Tutorial

  1. Using LOG with a base of 10:

    • Example: =LOG(100)
    • Result: 2 (since 10^2 = 100)

  2. Using LOG with a different base:

    • Example: =LOG(8, 2)
    • Result: 3 (since 2^3 = 8)

Use Cases and Scenarios

  1. Finance: Calculating compound interest or investment growth.
  2. Data Analysis: Scaling data for analysis or visualization.
  3. Mathematical Calculations: Solving exponential equations or scientific calculations.

Related Functions

  • LN: Returns the natural logarithm of a number.
  • EXP: Calculates the value of Euler's number raised to the power of a given number.

Related Articles