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
|
||
2
|