Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Excel LN Function

Excel LN Function

Figure 1.  Using the Ln Function

Generic Formula

LN(number)

Explanation

The Excel LN function returns the result as the natural logarithm of the numeric value entered in the cell.

The LN function is an inbuilt function in Microsoft Excel that is categorized as a Math/Trig Function. It can be utilized as a worksheet function (WS) in Microsoft Excel. the LN function can be used as part of the formula in a cell.

Number

The numeric value in the Ln function and must be greater than 0 and The LN function gives a number as result.

In the example below, the Microsoft Excel Ln function is used to get the natural logarithms of numbers

Example

Figure 2. Ln Function Error

Excel Ln Function Errors

If you get an error from the Excel Ln function, this is likely to be one of the following:

Errors

#NUM!- This error occurs if the numeric value argument supplied is less than or equal zero.

#VALUE!This error occurs if the supplied number is non-numeric.

Example below:

Figure 3.  Ln Function Error

Usage notes

The natural logarithm function is the equivalent to logarithmic base e of a number. Where e is Euler’s number.

= LN( number) = LOG( number, e)

 

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
I need a formula to convert the numbers in column A and column B into values to get a linear relationship
Solved by V. H. in 60 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc