This Excel tutorial explains how to use the Excel LOG function with syntax and examples.
base is optional. This is the base to use to calculate the logarithm of a number. If this parameter is omitted, the LOG function will use a base of 10.
Based on the spreadsheet above, the following Excel LOG examples would return:
Description
The Microsoft Excel LOG function returns the logarithm of a number to a specified base.Syntax
The syntax for the Microsoft Excel LOG function is:LOG( number, [base] )
Parameters or Arguments
number is a numeric value that must be greater than 0.base is optional. This is the base to use to calculate the logarithm of a number. If this parameter is omitted, the LOG function will use a base of 10.
Applies To
The LOG function can be used in the following versions of Microsoft Excel:- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Excel Function
The LOG function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
- VBA function (VBA)
Example (as Worksheet Function)
Let's look at some Excel LOG function examples and explore how to use the LOG function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel LOG examples would return:
=LOG(A1) Result: 1.301029996 =LOG(A1, 10) Result: 1.301029996 =LOG(A1, A2) Result: 0.930676558 =LOG(A2, 5.1) Result: 1.975690972 =LOG(200, 3) Result: 4.822736302
