Documentation/How Tos/Calc: COMPLEX function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:38, 17 July 2018 by Sancho (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_COMPLEX_function&oldid=243378"
Views
Personal tools
Navigation
Print/export
Tools