Returns a complex number, given real and imaginary parts.
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.