The COMPLEX () is an engineering function which takes "real_num, i_num" as argument and converts the real and imaginary coefficients into complex number of the form x + yi or x + yj.
Formula:
=COMPLEX (real_num, i_num, suffix) In the above syntax, the argument real_num denotes the real coefficient of the complex number; argument i_num denotes the imaginary coefficient of the complex number; argument suffix represents the imaginary component of the complex number. If omitted, suffix is assumed to be "i".
Video Tutorial:
Let us see how the complex function converts the real and imaginary co-efficient in to complex number,with the help of the below video.