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:

  

  where:

  

  and:

  

  and:

  

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

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

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

	A	B
1	IMSQRT Formula	Value
2	IMSQRT("1+i")	1.09868411346781+0.455089860562227i