COMPLEX function

From Apache OpenOffice Wiki
Jump to: navigation, search

COMPLEX

Returns a complex number, given real and imaginary parts.

This function is only available if the Analysis AddIn is installed.

Syntax:

COMPLEX(realpart; imaginarypart; suffix)

returns a complex number as text, in the form a+bi or a+bj.
realpart and imaginarypart are numbers. suffix is optional text i or j (in lowercase) to indicate the imaginary part of the complex number; it defaults to i.

Example:

COMPLEX(3; 4; "i")

returns the text 3+4i.

COMPLEX(2; -3; "j")

returns the text 2-3j.

Issues:

  • This function currently appears in the AddIn category of the Function Wizard.




See Also

Personal tools