LN function

Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Syntax

LN(number)

Argument

Description

number

The positive real number for which you want the natural logarithm.

General remarks

LN is the inverse of the EXP function.

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)
=LN(86)Natural logarithm of 86 (4.454347)
=LN(2.7182818)Natural logarithm of the value of the constant e (1)
=LN(EXP(3))Natural logarithm of e raised to the power of 3 (3)
Rate this content:
Not helpfulSomewhat helpfulHelpfulVery helpfulSolved my problem 
 
Share your feedback about this topic