How to use the IMLN Function in Excel office 365?
Tags: tousetheimlnfunction, excel, excelfunctions
Published: 2021-08-31 01:22:04

---
title: How to use the IMLN Function in Excel office 365?
published: true
date: 2021-08-30 19:42:25 UTC
tags: ToUseTheIMLNFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imln-function-in-excel-office-365/
---

In this article, you will learn how to use the **IMLN Function In Excel Office 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## IMLN Function

The **IMLN function** returns the **complex natural logarithm of the complex number** (inumber) having both **real & imaginary parts**.

## IMLN Function Syntax

```
=IMLN (inumber)
```

**Syntax Explanation:**

**inumber:** complex number for which you want the complex natural logarithm.

## Example1

- Firstly, you have to  **create a sample data**  with input  **complex number**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-45.png)<figcaption>Sample data</figcaption>

- Then, you need to get the ** complex natural logarithm**  of the  **input complex number**.
- Now, you have to use the following  **formula ** to calculate  **IMLN Function**.

```
=IMLN (A2)
```

**A2:** complex number (inumber) provided as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/IMLN-Function.png)<figcaption>IMLN Function</figcaption>

- After that, the  **formula ** returns the  **complex natural logarithm of the complex number.**
- Now, the **natural logarithm of a complex number** is:

```
(4 + 3i) = loge (4 + 3i) = ln (4 +3i) = ln (42 +32)1/2 + i tan-1( 3 / 4 )
```

- At last, you have to copy the  **formula ** to the other remaining cells using  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Copy-to-other-cells-5.png)<figcaption>Copy to other cells</figcaption>

## Example2

- Firstly, you have to  **create a sample data**  with input  **complex number**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Sample-data-7.png)<figcaption>Sample data</figcaption>

- Then, you need to get the ** complex natural logarithm**  of the  **input complex number**.
- Now, you have to use the following  **formula ** to calculate  **IMLN Function**.

```
=IMLN (A2)
```

**A2:** complex number (inumber) provided as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-IMLN-Function.png)<figcaption>IMLN Function</figcaption>

- After that, the  **formula ** returns the  **complex natural logarithm of the complex number.**
- Now, the **natural logarithm of a complex number** is:

```
(4 + 3i) = loge (4 + 3i) = ln (4 +3i) = ln (42 +32)1/2 + i tan-1( 3 / 4 )
```

- At last, you have to copy the  **formula ** to the other remaining cells using  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Copy-to-other-cells-3.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- [IMDIV Function](https://geekexcel.com/how-to-use-the-imdiv-function-in-excel-office-365/)
- [IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)
- [IMPRODUCT Function](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)

## Sum-Up

In the above short tutorial, we have illustrated **how to use the IMLN Function In Excel Office 365**. Hope you like this article. Please feel free to state your **query** or **feedback** for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[How to use Excel COVARIANCE.S function in Excel Spreadsheet?](https://geekexcel.com/how-to-use-excel-covariance-s-function-in-excel-spreadsheet/)**
- **[Get the Current Worksheet Name Only in Excel Office 365!!](https://geekexcel.com/get-the-current-worksheet-name-only-in-excel-office-365/)**
- **[How to use the IMSQRT Function in Excel Office 365?](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)**
- **[How to use the IMDIV Function in Excel office 365?](https://geekexcel.com/how-to-use-the-imdiv-function-in-excel-office-365/)**