Complex Number functions
From Apache OpenOffice Wiki
List of Calc Complex Number functions
Complex numbers are a mathematical concept, and have a real and an imaginary part. In Calc, they are represented by text, for example as a + bi or a + bj. The following functions create or manipulate that text.
The representation of the numbers in the text can have up to 15 significant digits. Scientific style is automatically used if needed. The decimal delimiter is always a dot, local style of numbers is not possible inside the text. The text may not contain any blanks.
COMPLEX | Returns a complex number, given real and imaginary parts as numbers. |
IMABS | Returns the absolute value of a complex number. |
IMAGINARY | Returns the imaginary part of a complex number. |
IMARGUMENT | Returns the argument of a complex number. |
IMCONJUGATE | Returns the complex conjugate of a complex number. |
IMCOS | Returns the cosine of a complex number. |
IMCOSH | Returns the hyperbolic cosine of a complex number. |
IMCSC | Returns the cosecant of a complex number. |
IMCSCH | Returns the hyperbolic cosecant of a complex number. |
IMCOT | Returns the cotangent of a complex number. |
IMDIV | Returns the result of dividing one complex number by another. |
IMEXP | Returns e to the power of a complex number. |
IMLN | Returns the natural logarithm of a complex number. |
IMLOG10 | Returns the base-10 logarithm of a complex number. |
IMLOG2 | Returns the base-2 logarithm of a complex number. |
IMPOWER | Returns a complex number raised to a power. |
IMPRODUCT | Returns the product of complex numbers. |
IMREAL | Returns the real part of a complex number. |
IMSEC | Returns the secant of a complex number. |
IMSECH | Returns the hyperbolic secant of a complex number. |
IMSIN | Return the sine of a complex number. |
IMSINH | Returns the hyperbolic sine of a complex number. |
IMSQRT | Returns the square root of a complex number. |
IMSUB | Returns the difference between 2 complex numbers. |
IMSUM | Returns the sum of complex numbers. |
IMTAN | Returns the tangent of a complex number. |
See Also