COMPLEX Function in Excel – Create complex number in Excel

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

 COMPLEX Function in Excel 1

  • 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

 COMPLEX Function in Excel 2

NOTE: #VALUE! – Error occurs if,

One or both of the supplied real_num or i_num arguments are non-numeric.

previous COMPLEX Function in Excel                                                                                                                next COMPLEX Function in Excel