LOG function in excel is used to calculate the logarithm of a given number but the catch is that the base for the number is to be provided by the user itself, it is an inbuilt function which can be accessed from the formula tab in excel and it takes two arguments one is for the number and another is for the base.
Syntax: =LOG( number, [base] )
The LOG function syntax has the following arguments:
- Number: The positive real number that you want to calculate the logarithm of.
-
Base: An optional argument that specifies the base to which the logarithm should be calculated.
If omitted, the [base] argument uses the default value 10 (i.e. the logarithm to the base 10 is calculated).
Example: Let’s look at some Excel LOG function examples and explore how to use the LOG function as a worksheet function in Microsoft Excel:
Syntax: =LOG(A2,B2)
Result:
Based on the Excel spreadsheet above, the following LOG examples would return:
Syntax: =LOG(A3,B3)
Result: 4
Syntax: =LOG(A4,B4)
Result: 3
Syntax: =LOG(A5,B5)
Result: -3
Syntax: =LOG(A6,B6)
Result: 0
Syntax: =LOG(A7,B7)
Result: 7.813781191
Syntax: =LOG(A8,B8)
Result: 0.333333333
Syntax: =LOG(A9,B9)
Result: 6
Syntax: =LOG(A10,B10)
Result: 2
Note: The LOG function allows you to get the logarithm of a number with a specified base.
