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:
Syntax: =LN(A2)
Result:
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.