Documentation/Calc Functions/IMSQRT

Function name:
IMSQRT

Category:
Add-in

Summary:
Calculates the principal square root of a complex number.

Syntax:
IMSQRT(ComplexNumber)

Returns:
Returns a text string giving the complex number that is the principal square root of the complex number passed as argument. The real part of the principal square root is non-negative, and its imaginary part has the same sign as the original complex number.

Arguments:
ComplexNumber is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, whose square root is to be determined. a and b are real numbers.


 * If ComplexNumber does not have an imaginary part (b equal to 0), the real part can be passed to IMSQRT as a number rather than a string.
 * If ComplexNumber is not a valid complex number, IMSQRT reports an invalid argument error (Err:502).

Details specific to IMSQRT function
For a complex number of the form a+bi, IMSQRT implements the following equation: sign(b)  ensures that the imaginary part of the complex number passed in the argument has the same sign as its principal square root.

Related LibreOffice functions:
IMEXP

IMLN

IMLOG10

IMLOG2

IMPOWER

ODF standard:
Section 6.8.24, part 2

Equivalent Excel functions:
IMSQRT