Complex Number Functions

Apache OpenOffice 4.1 Calc Guide

Appendix B — Description of Functions

< Previous Section

Next Section >

• Functions Available in Calc
  • Terminology: Numbers and Arguments
• Mathematical Functions
• Financial Analysis Functions
  • A Note About Dates
  • A Note About Interest Rates
• Statistical Analysis Functions
• Date and Time Functions
• Logical Functions
• Informational Functions
• Database Functions
• Array Functions
• Spreadsheet Functions
• Text Functions
• Converting Decimal, Binary, Octal, Hexadecimal
• Complex Number Functions

< Previous Page

Next Page >

Complex Number Functions

Table 48 Complex number functions

Syntax	Description
COMPLEX(real_num; i_num; suffix)	Returns a complex number from a real coefficient and an imaginary coefficient. Real_num is the real coefficient of the complex number. I_num is the imaginary coefficient of the complex number. Suffix is a list of options, "i” or "j”.
IMABS(complex_number)	Returns the absolute value (modulus) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMAGINARY(complex _number)	Returns the imaginary coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMARGUMENT(complex _number)	Returns the argument (the phi angle in radians) of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMCONJUGATE(complex _number)	Returns the conjugated complex complement to a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMCOS(complex_number)	Returns the cosine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMDIV(numerator; denominator)	Returns the division of two complex numbers. Numerator, Denominator are entered in the form "x + yi" or "x + yj".
IMEXP(complex_number)	Returns the power of e (the Eulerian number) and the complex_number. The complex_number is entered in the form "x + yi" or "x + yj".
IMLN(complex_number)	Returns the natural logarithm of a complex_number. The complex_number is entered in the form "x + yi" or "x + yj”.
IMLOG10(complex _number)	Returns the common logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMLOG2(complex _number)	Returns the binary logarithm of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMPOWER(complex _number; number)	Returns the integer power of a complex_number. The complex number is entered in the form "x + yi" or "x + yj". Number is the exponent.
IMPRODUCT(complex _number; complex_number_1; …)	Returns the product of up to 29 complex_numbers. The complex numbers are entered in the form "x + yi" or "x + yj".
IMREAL(complex _number)	Returns the real coefficient of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMSIN(complex_number)	Returns the sine of a complex_number. The complex number is entered in the form "x + yi" or "x + yj".
IMSQRT(complex_number)	Returns the square root of a complex_number. The complex numbers are entered in the form "x + yi" or "x + yj".
IMSUB(complex_number_1; complex_number_2)	Returns the subtraction of two complex_numbers. The complex_numbers are entered in the form "x + yi" or "x + yj".
IMSUM(complex_number; complex_number_1; …)	Returns the sum of up to 29 complex numbers. The complex_numbers are entered in the form "x + yi" or "x + yj".