COMPLEX

COMPLEX(real_num, i_num [,suffix])

Returns the complex number given real and imaginary coefficients.

real_num	The real coefficient of the complex number.
i_num	The imaginary coefficient of the complex number.
suffix	(Optional) The suffix for the imaginary component of the complex number.

REMARKS

* If "real_num" is not numeric, then #VALUE! is returned.
* If "i_num" is not numeric, then #VALUE! is returned.
* If "suffix" is left blank, then "i" is used.
* If "suffix" is not either "i" or "j", then #VALUE! is returned.
* If "suffix" is not in lowercase, then #VALUE! is returned.
* You can use the IMABS function to return the absolute value of a complex number.
* You can use the IMAGINARY function to return the imaginary coefficient of a complex number.
* You can use the IMCONJUGATE function to return a complex conjugate.
* You can use the IMEXP function to return the exponential of a complex number.
* You can use the IMPRODUCT function to return the product of two or more complex numbers.
* You can use the IMREAL function to return the real coefficient of a complex number.
* You can use the IMSQRT function to return the square root of a complex number.
* You can use the IMSUB function to return the difference of two complex numbers.
* You can use the IMSUM function to return the sum of two or more complex numbers.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=COMPLEX(3, 3) = 3+3i
2	=COMPLEX(3, 4, "i") = 3+4i
3	=COMPLEX(3, 4, "j") = 3+4j
4	=COMPLEX(0, 1) = i
5	=COMPLEX(1, 0) = 1
6	=COMPLEX(3, 4, "I") = #VALUE!
7	=COMPLEX(1, 0, "J") = #VALUE!
8	=COMPLEX(1, 0, "a") = #VALUE!