COMPLEX Function Explained
The COMPLEX function in Microsoft Excel is used to convert a real number to a complex number of the form x + yi or x + yj, where x and y are numbers and i or j is the imaginary unit. It takes two arguments: real_num and i_num, which are the real and imaginary coefficients of the complex number, respectively. The function returns a complex number.
COMPLEX Function Syntax
COMPLEX(real_num, i_num, suffix)
- real_num: The real number part of the complex number.
- i_num: The imaginary number part of the complex number.
- suffix: The suffix for the imaginary number part of the complex number. The default value is “i”.