How to use the IMSQRT Function in Excel Office 365?
Tags: tousetheimsqrtfuncti, excel, excelfunctions
Published: 2021-08-27 12:19:28

---
title: How to use the IMSQRT Function in Excel Office 365?
published: true
date: 2021-08-26 16:33:48 UTC
tags: ToUseTheIMSQRTFuncti,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/
---

The **IMSQRT function** returns the **complex Square root 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)**

## IMSQRT Function Syntax

```
=IMSQRT (inumber)
```

**Syntax Explanation:**

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

## Example1

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

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

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

```
=IMSQRT (A2)
```

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

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

- Now, the the formula returns the **complex Square root of the complex number**.
- 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-1-1024x459.png)<figcaption>Copy to other cells</figcaption>

## Example2

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

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

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

```
=IMSQRT (A2)
```

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

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

- Now, the the formula returns the **complex Square root of the complex number**.
- 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/Use-CtrlD.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- **[IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)**
- [**IMSUM Function**](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)
- **[IMSUB Function](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)**

**NOTES:**

- The formula returns the **#NUM! error** if the complex number doesn’t have **lower case i or j ** (iota).
- The formula returns the **#VALUE! Error** if the complex number doesn’t have correct **complex number format**.

## Verdict

We hope that this short tutorial gives you guidelines to  **use the IMSQRT**  **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 Also:**

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