LOG function

Returns the logarithm of a number to the base you specify.

Syntax

LOG(number,base)

Argument

Description

Remarks

number

The positive real number for which you want the logarithm.

  • None.

base

The base of the logarithm.

  • If base is omitted, it is assumed to be 10.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
3
4
AB
FormulaDescription (Result)
=LOG(10)Logarithm of 10 (1)
=LOG(8,2)Logarithm of 8 with base 2 (3)
=LOG(86,2.7182818)Logarithm of 86 with base e (4.454347)
Rate this content:
Not helpfulSomewhat helpfulHelpfulVery helpfulSolved my problem 
 
Share your feedback about this topic