How to use the IMDIV Function in Excel office 365?
Tags: tousetheimdivfunctio, excel, excelfunctions
Published: 2021-08-30 02:22:28

---
title: How to use the IMDIV Function in Excel office 365?
published: true
date: 2021-08-27 17:38:38 UTC
tags: ToUseTheIMDIVFunctio,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imdiv-function-in-excel-office-365/
---

The **IMDIV function** returns the **division of the complex number** (inumber) having both **real & imaginary parts**. In this article, we are going to see how to  **use the IMSQRT**   **Function In Excel Office 365.**  Let’s get into this article!! Get an 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)**

## IMDIV Function Syntax

```
=IMDIV (inumber1 , inumber2)
```

**Syntax Explanation:**

- **inumber 1**  **:** First complex number which is to be divided.
- **inumber 2 :** Second complex number which is to be divided by the first complex number.

## Example1

- Firstly, you have to  **create a sample data**  to get the  **complex division**  of the  **input complex number**  (inumber).

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

- Then, you need to calculate the  **IMDIV**  **Function**  by using the following  **formula**.

```
=IMDIV (A2, B2)
```

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

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

- Now, the the formula returns the  **complex division of the complex number**.
- After that, **mathematical formulation** is performed by using given **formula**.

```
5 + i - ( 4 - i ) = (5 - 4) + ( i + i )= 1 + 2i
```

- Finally, you need 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-2-1024x361.png)<figcaption>Copy to other cells</figcaption>

## Example2

- Firstly, you have to  **create a sample data**  to get the  **complex division**  of the  **input complex number**  (inumber).

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

- Then, you need to calculate the  **IMDIV**  **Function**  by using the following  **formula**.

```
=IMDIV (A2, B2)
```

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

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

- Now, the the formula returns the  **complex division of the complex number**.
- After that, **mathematical formulation** is performed by using given **formula**.

```
5 + i - ( 4 - i ) = (5 - 4) + ( i + i )= 1 + 2i
```

- Finally, you need 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-1024x365.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- [IMSQRT Function](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)
- [IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)

## Wind-Up

We hope that this short tutorial gives you guidelines to **use the IMDIV**  **Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[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 IMSUB Function in MS Excel 365? – { With Examples }](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)**
- **[Use IMSUM Function in MS Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)**
- **[How to Use IMPRODUCT Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)**
- **[How to use the IMTAN Function in Excel office 365?](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)**