LOG Function Examples – Excel, VBA, & Google Sheets

This Tutorial demonstrates how to use the Excel LOG Function in Excel to calculate the logarithm of a number to a specified base.

LOG Main Function

LOG Function Overview

The LOG Function Calculates the logarithm of a number to a specified base.

To use the LOG Excel Worksheet Function, select a cell and type:

log formula syntax

(Notice how the formula inputs appear)

LOG Function Syntax and Inputs:

number – A number.

base – OPTIONAL. The base of the logarithm. Blank as default.

AutoMacro - VBA Code Generator

LOG Function 

The LOG Function returns the logarithm of a number to the specified base.

LOG-01

LOG Function – Base 10

The LOG Function will return the logarithm of a number to base 10 if the second argument is omitted.

LOG 02

Alternatively, the LOG10 Function can also be used. To learn more, click here.

LOG Function – Base ‘e’

The LOG Function can return the logarithm of a number to base ‘e’.

LOG 03

Alternatively, the LN Function can also be used. To learn more, click here.

LOG & POWER Function

The LOG Function is a reverse of the POWER Function. The LOG Function returns the power to which the given base was raised.

Let’s say we raise 7 to the power of 3.

LOG 04 01

The resulting number when entered in the LOG Function to the base 7 will return the power.

LOG 04 02

To learn more about the POWER Function, click here.

LOG Function – Negative Number/Zero

The LOG Function will return an error if the argument is zero or a negative number. 

LOG 05 01

LOG 05 02

LOG in Google Sheets

The LOG Function works exactly the same in Google Sheets as in Excel:

LOG Gsheet

Additional Notes

Use the LOG Function to calculate the logarithm of a number to a specified base. Simply enter any number directly into the formula, or reference a cell containing a number.

LOG Examples in VBA

You can also use the LOG function in VBA. Type:
application.worksheetfunction.log(number,base)
For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!