IMSQRT Excel Formula

Author Zaheer    Category Formulas     Tags ,

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.

Post comment