COMPLEX Function in Excel takes two arguments, representing the real and the imaginary coefficients of a complex number, and creates a complex number.
Syntax of COMPLEX Function in Excel
COMPLEX( real_num, i_num, [suffix] )
Where
real_num – The real component of the complex number
i_num – The imaginary component of the complex number
[suffix] – An optional text argument which is generally i or j which is suffix for imaginary component
If omitted, the [suffix] argument uses the default value “i”.
Example of COMPLEX Function in Excel
Formula
- From Row number 2 to 4 COMPLEX Function takes up real component, imaginary component and suffix.
- Row number 5 COMPLEX Function takes up real component, imaginary component, which results in a complex number with default suffix “i”
Result
NOTE: #VALUE! – Error occurs if,
One or both of the supplied real_num or i_num arguments are non-numeric.