LN function in Excel

What is LN function in Excel?

The LN function is one of the math functions of Excel.

It returns the natural logarithm of a number.

We can find this function in Math & trig category of insert function Tab.

How to use LN function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select LN function

6. Then select ok

math and trig function category in excel

7. In the function arguments Tab you will see LN function

8. Number section is the positive real number for which you want the natural logarithm

9. You will see results in the formula result section

LN function in excel

Examples of LN function in excel

Example 1:

How to use LN function in excel

You can see examples of LN function below:

Examples of LN function in excel
ln(1) ----->>>>answer is  0

ln(2) ----->>>>answer is  0.693

ln(3) ----->>>>answer is  1.098

ln(4) ----->>>>answer is  1.386

ln(5) ----->>>>answer is  1.609

What is the purpose of LN function?

It returns the natural logarithm of a number.

What is the Return value of LN function?

It returns a number.

How many arguments does LN function have?

This function has just 1 Argument.

The argument of LN function is number.

Number section is the positive real number for which you want the natural logarithm.

The argument of LN function is required and not optional.

LN(number) = number

Which version of excel supports LN function?

This function is available for all excel versions (2003-2019)

Errors in LN function

LN related functions :

Leave a Reply

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