COMPLEX function
COMPLEX(real,
imaginary, suffix?) COMPLEX(real;
imaginary; suffix?)
real
Number or { Number }
The real part of the complex number.
imaginary
Number or { Number }
The imaginary part of the complex number.
suffix
Text or { Text } (optional)
The suffix ("i" or "j"). If omitted, it is assumed to be "i".
Returns
Text or { Text }
A complex number as text.
Returns a complex number as text.
Examples
COMPLEX(24,
2)COMPLEX(24; 2)
Returns "24+2i".
COMPLEX(24, 2,
"j")COMPLEX(24; 2;
"j")
Returns "24+2j".
COMPLEX({ 24, 48 }, 2,
"j")COMPLEX({ 24;
48 }; 2; "j")
Returns the array { "24+2j", "48+2j" }{ "24+2j"; "48+2j" }.