Difference between revisions of "Documentation/How Tos/Calc: COMPLEX function"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 65: Line 65:
  
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]]
 
* [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]]
 
* [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]]
 
* [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]]

Revision as of 07:38, 17 July 2018


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
Tools