How to use the Excel LN function

LN function in excel is the mathematical trigonometry function that is used for calculating the natural logarithm of a number. Where LN denotes the logarithm statement and as per the syntax we just need to put any number who logarithm value we need to find. LN value of 1 is 0 and the LN value of e is 1, so for each value coming after these will be having the LN value more than 0 if any number is used. We can also choose any exponential or raise to power value in the syntax.

In simple terms logarithm means, “How many of one number do we multiply to get another number?”

Syntax: =LN(number)

The LN function syntax has the following arguments:

  • Number: A numeric value that must be greater than 0.

Example: Let’s look at some Excel LN function examples and explore how to use the LN function as a worksheet function in Microsoft Excel:

Excel LN function - How to use the Excel LN function

Syntax: =LN(A2)


Excel LN function 1 - How to use the Excel LN function

Based on the Excel spreadsheet above, the following LN examples would return:

Syntax: =LN(A3)
Result: -0.693147181

Syntax: =LN(A4)
Result: 1.667706821

Syntax: =LN(A5)
Result: 1.098612289

Syntax: =LN(A6)
Result: 2.995732274

Syntax: =LN(A7)
Result: 1.704748092

Syntax: =LN(A8)
Result: 0.916290732

Syntax: =LN(A9)
Result: 4.605170186

Note: The natural logarithm function is the inverse of the exponential function and is used to model exponential decay. The function is equivalent to log base e of a number, where e is Euler’s number.

Add a Comment

Your email address will not be published. Required fields are marked *