Learn how to use the Excel LN function with syntax and examples.
The Microsoft Excel LN function returns the natural logarithm of a number.
The syntax for the Microsoft Excel LN function is:
LN( number )
number is a numeric value that must be greater than 0.
The LN function can be used in the following versions of Microsoft Excel:
The LN function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel LN function examples and explore how to use the LN function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel LN examples would return:
=LN(A1) Result: 2.995732274 =LN(A2) Result: 3.218875825 =LN(A3) Result: 4.605170186 =LN(200) Result: 5.298317367
(scroll to see more)