IMSQRT

Description

Returns the square root of a complex number in x + yi or x + yj text format.

Sample Usage


Syntax

IMSQRT(inumber)

The IMSQRT function syntax has the following arguments:

  • Inumber    Required. A complex number for which you want the square root.

Remarks

  • Use COMPLEX to convert real and imaginary coefficients into a complex number.

  • The square root of a complex number is:

    Equation

    where:

    Equation

    and:

    Equation

    and:

    Equation

In order to use the IMSQRT formula, start with your edited Excellentable

imsqrt1.png

Then type in the IMSQRT formula in the area you would like to display the outcome:

imsqrt2.png

imsqrt3.png

By adding the values you would like to calculate the IMSQRT formula for, Excellentable will generate the outcome:

imsqrt4.png



There were errors rendering macro:

  • An unknown error occurred.