How to use the IMCONJUGATE Function in Excel office 365?
Tags: tousetheimconjugatef, excel, excelfunctions
Published: 2021-09-01 07:08:33

---
title: How to use the IMCONJUGATE Function in Excel office 365?
published: true
date: 2021-08-31 15:02:23 UTC
tags: ToUseTheIMCONJUGATEF,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imconjugate-function-in-excel-office-365/
---

In this article, we are going to see how to  **use the IMCONJUGATE**  **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)**


## IMCONJUGATE Function

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

## IMCONJUGATE Function Syntax

```
=IMCONJUGATE (inumber)
```

**Syntax Explanation:**

**inumber:** complex number having both real & imaginary.

## Example1

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

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

- Then, you need to get the **complex conjugate of the input complex number** (inumber).
- Now, you have to use the following  **formula ** to calculate  **IMCONJUGATE**  **Function**.

```
=IMCONJUGATE (A2)
```

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

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

- After that, the  **formula ** returns the **complex conjugate of the complex number.**

```
COMPLEX CONJUGATE (4 + 3i) = 4 - 3i
```

- Finally, 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-9.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-10.png)<figcaption>Sample data</figcaption>

- Then, you need to get the **complex conjugate of the input complex number** (inumber).
- Now, you have to use the following  **formula ** to calculate  **IMCONJUGATE**  **Function**.

```
=IMCONJUGATE (A2)
```

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

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

- After that, the  **formula ** returns the **complex conjugate of the complex number.**

```
COMPLEX CONJUGATE (4 + 3i) = 4 - 3i
```

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

**Check this too:**

- [IMLN Function](https://geekexcel.com/how-to-use-the-imln-function-in-excel-office-365/)
- [IMSQRT Function](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)
- [IMSUM Function](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)
- [IMPRODUCT Function](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)

## Wind-Up

We hope that this short tutorial gives you guidelines to **use the IMCONJUGATE**  **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 Copy a Range of Cells in Microsoft Excel 365?](https://geekexcel.com/how-to-copy-a-range-of-cells-in-microsoft-excel-365/)**
- **[How to Copy a Cell Formatting from One Cell to Other Cells in Excel 365?](https://geekexcel.com/how-to-copy-a-cell-formatting-from-one-cell-to-other-cells-in-excel-365/)**
- **[Copy a Formula in Excel Office 365 ~ Simple Guide!!](https://geekexcel.com/how-to-copy-a-formula-in-excel/)**
- **[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/)**