Open links in new tab
  1. How to Calculate a Logarithm in Excel (6 Methods)

    • A logarithm is a mathematical operation that quantifies how a specific number, known as the base, grows by repeatedly multiplying itself to reach another number. Logarithms find practical applications i… See more

    Method 1 – Using Log Function

    The LOG functionallows you to calculate logarithms with a specified base. If, ba = x, then Logbx = a For example, if 52 = 25, then Log525 = 2. Below is a dataset that we’ll use t… See more

    ExcelDemy
    Method 2 – Using The Log10 Function

    The LOG10 function calculates logarithms with a fixed base of 10. You don’t need to manually select the base;it’s always 10. Steps 1. Enter the formula in cell C5: 1. Press ENT… See more

    ExcelDemy
    Method 3 – Using The Ln Function

    The LN function computes the natural logarithm (base (e)) of a number. The mathematical constant (e) is approximately 2.71828. Steps 1. Enter the formula in cell C5: 1. Pres… See more

    ExcelDemy
    Feedback
     
  1. LOG function

    • Description Returns the logarithm of a number to the base you specify.
    • Syntax LOG (number, [base]) The LOG function syntax has the following arguments: Number Required. ...
    • Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. ...
    support.microsoft.com/en-us/office/log-function-4e82f196-1ca9-4747-8fb0-6c4a3abb3280
    support.microsoft.com/en-us/office/log-function-4e82f196-1ca9-4747-8fb0-6c4a…
    Was this helpful?
  2. People also ask
  3. How to Use LOG Function in Excel: 10 Methods - ExcelDemy

  4. Excel LOG function | Exceljet

    The Excel LOG function returns the logarithm of a given number, using a supplied base. The base argument defaults to 10 if not supplied.

  5. Excel LOG Function - Calculate logarithm (log)

    Nov 9, 2023 · LOG Function Examples – Excel, VBA, & Google Sheets. This tutorial demonstrates how to use the LOG Function in Excel to calculate the logarithm of a number to a specified base.

  6. LOG function - Microsoft Support

  7. MS Excel: How to use the LOG Function (WS)

    The Microsoft Excel LOG function returns the logarithm of a number to a specified base. The LOG function is a built-in function in Excel that is categorized as a Math/Trig Function.

  8. Mastering the LOG Function in Excel: A Beginner's …

    The LOG function in Excel is straightforward yet powerful, with a syntax that reads =LOG (number, [base]). Here's a breakdown: number: The positive real number you wish to find the logarithm of. [base]: The base of the logarithm. …

  9. LOG10 function - Microsoft Support

  10. LOG in Excel (Formula, Examples) | How to Use LOG …

    Apr 29, 2023 · LOG function in Excel calculates the logarithm of a given number to a supplied base or returns the natural logarithm of a number. E.G. 1000 = 10 × 10 × 10 = 10 3 , the “logarithm to base 10” of 1000 is 3, i.e. logarithm counts …

  11. How to Use the LOG Function in Excel: Usabilities, Examples, and ...