## 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

- Click on
**an empty**cell (like F5 )

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

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

4. Select **math and trig** category

5. Select **LN **function

6. Then select **ok**

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

## Examples of **LN** function in excel

**Example 1:**

**How to use LN function in excel**

You can see examples of LN function below:

**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?

**LN**

It returns the **natural logarithm** of a number.

## What is the Return value of **LN** function?

**LN**

It returns a number.

## How many arguments does **LN** function have?

**LN**

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?

**LN**

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

## Errors in **LN** function

**LN**