# IMSQRT Excel Formula

In the following tutorials, here you will learn and be guided on the usage and syntax of the IMSQRT functions present in the Excel application.

**Description:**

The IMSQRT function returns square root of complex number a plus b (a+b) or x plus yi (x+yi) in text format

**Syntax:**

The IMSQRT function syntax is as follow:

= IMSQRT (inumber)

Where: iNumber is complex number for which you like the square root.

**Note**:

When the complex number that you enter as argument is in the format other than the x+iy or x+jy, then the IMSQRT function returns as the #NUM! Error value

**Excel IMSQRT Function Samples: **

Here are some of the examples of the Excel IMSQRT function used to calculate square root of various complex numbers… The spread sheet on left shows that formula and the spread sheet on right shows the result:

**Formulas Results:**

=IMSQRT( “I” ) 0.707106781186548+0.707106781186547i

=IMSQRT( “2-i” ) 1.45534669022535-0.343560749722512i

=IMSQRT( “5+2i” ) 2.27872385417085+0.438842116902255i

=IMSQRT( 6 ) 2.44948974278318

=IMSQRT( “-2-4i” ) 1.11178594050284-1.79890743994787i

**IMSQRT Function Common Errors: **

- #NUM! – It happen when the supplied NUMBER argument is not identified as the complex number

- #NAME? – It happen when the Analysis Tool Pak adds on is not enabled in the Excel. You will have to let the add-on if you like to use Excel engineering functions.

For you to do this in Excel 2003, you have to do the following:

- From the Tools drop down menu, you have to choose the option Analysis Tool Pak and then click OK.

- An add-on window will pop out and from here, you need to choose the option Analysis Tool Pal and then click OK

**For you to do this in Excel 2007, you have to do the following:**

- Click Microsoft button just on top of the left spreadsheet and then choose Excel Options button

- From Menu, select Add on located at the left hand side

- In Manage box, you have to choose Excel Add- Ins and then click GO

- An Add-on window will pop out. From here, you have to choose option Analysis Tool Pak and then click OK

Suppose, if you like to look for the square root of complex number ‘ 1 plus 2i’, then the formula for IMSQRT Function must be written as the following:

**= IMSQRT (“1+2i”)**

The mentioned function above returns to the square root of complex number ‘`1 + 2i’ and the square root which return would also be complex number “1.2720196+0.7861513i”.

You can supply cell reference as well and the argument to IMSQRT Function.

**For instance, the formula =IMSQRT (C4)**

It will find the square root of complex number which is present in example above. As a result, this is the process how you can look for the square root of the given complex number with the use of the IMSQRT function presented in the Excel 2010 Application.

These are the essential things that you can accomplish in utilizing IMSQRT function in Excel. There are countless tutorials that you can locate online through various Microsoft site. You can look through online and learn further about IMSQRT function. Additionally, you can also look and find for a few more formulas to use.

### Further readings

## Post comment

## Categories

## Recent Posts

- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro