How to use the IMARGUMENT Function in Excel office 365?
Tags: tousetheimargumentfu, excel, excelfunctions
Published: 2021-09-01 07:09:11

---
title: How to use the IMARGUMENT Function in Excel office 365?
published: true
date: 2021-08-31 15:03:25 UTC
tags: ToUseTheIMARGUMENTFu,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imargument-function-in-excel-office-365/
---

In this post, we will explain to you how to **use the IMARGUMENT Function In Excel Office 365.** Let’s see them below!! 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)**

## IMARGUMENT Function

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

## IMARGUMENT Function Syntax

```
=IMARGUMENT (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-49.png)<figcaption>Sample data</figcaption>

- Then, you need to extract the **argument part of the complex number** (inumber).
- Now, you have to use the following  **formula ** to calculate  **IMARGUMENT**  **Function**.

```
=IMARGUMENT (A2)
```

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

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

- After that, the  **formula ** returned the **absolute value** which is 5 here.

```
IMARGUMENT (4 + 3i) = (42+32)1/2= (16+9)1/2 = 5
```

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

- Then, you need to extract the **argument part of the complex number** (inumber).
- Now, you have to use the following  **formula ** to calculate  **IMARGUMENT**  **Function**.

```
=IMARGUMENT (A2)
```

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

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

- After that, the  **formula ** returned the **absolute value** which is 5 here.

```
IMARGUMENT (4 + 3i) = (42+32)1/2= (16+9)1/2 = 5
```

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

**Check this too:**

- [IMLOG10 Function](https://geekexcel.com/how-to-use-the-imlog10-function-in-excel-office-365/)
- [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/)
- [IMLOG2 Function](https://geekexcel.com/how-to-use-the-imlog2-function-in-excel-office-365/)

## Wrap-Up

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

**Read Ahead:**

- **[Excel Formula to SUM Absolute Value in a Range ~ A Simple Guide!!](https://geekexcel.com/excel-formula-to-sum-absolute-value-in-a-range-simple-guide/)**
- **[How to SUM Absolute Values in a Range in Excel Office 365?](https://geekexcel.com/how-to-sum-absolute-values-in-a-range-in-excel-office-365/)**
- **[use the IMDIV Function in Excel office 365](https://geekexcel.com/how-to-use-the-imdiv-function-in-excel-office-365/)**
- **[How to use ABS function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)**
- **[How to Get Full File Name and Path in Excel Office 365?](https://geekexcel.com/how-to-get-full-file-name-and-path-in-excel-office-365/)**