Excel LN Function

The Excel LN function returns the natural logarithm (base e) of a given number.

The LN function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the LN function can be used as part of a formula in a worksheet cell.

Syntax

LN(number)

Parameters

Return Value

Returns the natural logarithm of a value.

Notes

• If the argument is a negative number, LN returns #NUM! error.
• If the argument is a non-numeric value, LN returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the LN function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=LN(B5)
Result: -0.693147181

=LN(B6)
Result: 0

=LN(B7)
Result: 1.386294361

=LN(B8)
Result: 2.302585093

=LN(B9)
Result: 3.218875825

=LN(B10)
Result: 3.912023005

=LN(B11)
Result: 4.605170186