# 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* For the Google documentation refer to support.google.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!