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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Bot: Adding Category: Documentation)
m (Robot: Automated text replacement %s)
Line 31: Line 31:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
[[Category: Documentation]]
+
[[Category: Documentation/Reference/Calc]]

Revision as of 09:03, 24 November 2009


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.


Template:Documentation/SeeAlso

Personal tools