COMPLEX

Syntax:

COMPLEX ( real-number , imaginary-number [ , suffix ] )

Description: Makes a complex number in x + yi or x + yj text format from the arguments.

Arguments:

Name	Type	Description
real-number	number	The real number coefficient.
imaginary-number	number	The imaginary number coefficient.
suffix	text	"`i`" or "`j`". If omitted, "`i`" is used.

Return Type and Value: text – The complex number string specified by the arguments.

If real-number has the value 0 and imaginary-number has a non-zero value, the resulting string contains just the real number. If real-number has a non-zero value and imaginary-number has a zero value, the resulting string contains just the imaginary number and suffix. If both real-number and imaginary-number have a zero value, the resulting string is "0".

However, if suffix is neither "i" nor "j", #VALUE! is returned.

example: