COMPLEX Function

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.

Learn MS Excel


Ask Questions

Ask Question