|
<< Click to Display Table of Contents >> COMPLEX (create complex number) |
Syntax:
COMPLEX(Real, Imag [, Suffix])
Description:
Creates a complex number in the form x+yi or x+yj from the specified Real and Imag.
With Suffix (optional) you can determine which letter should be used for the imaginary unit: either "i" or "j" (lower case!). If Suffix is not specified, "i" is automatically used.
Tip:
To enter complex numbers in cells, you can either make use of the COMPLEX function or simply type them in. For example, the complex number 2+4i can be entered either as =COMPLEX(2, 4) or simply as 2+4i.
The same applies for formulas – except for the fact that complex numbers have to be surrounded by double quotation marks ("). For example, instead of typing =IMPOWER(COMPLEX(2, 4)), you could also type =IMPOWER("2+4i").
Example:
COMPLEX(2, 4) returns 2+4i
COMPLEX(2, 4, "i") returns 2+4i as well
COMPLEX(2, 4, "j") returns 2+4j
See also: