COMPLEX

Using the Excel COMPLEX Function

Summary

The Excel COMPLEX function converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Syntax

=COMPLEX (real_num, i_num, [suffix])

Syntax Breakdown

Real Num
Required. Real coefficient of a complex number.

I Num
Required. Imaginary coefficient of a complex number.

Suffix
Optional. Suffix for the imaginary component of the complex number, with options of either "i" or "j". If omitted, the argument is assumed to be "i".

The argument is case sensitive. Using "I" or "J" will result in the #VALUE! error being returned.


Usage Notes

COMPLEX converts real and imaginary coefficients into a complex number of the form x + yi or x + yj, where x represents the real number and y represents the imaginary number.

Complex numbers have two parts: the real number and the imaginary number.

COMPLEX Errors
The COMPLEX function returns the #VALUE! error in the following instances:

1) If real_num is non-numeric;

2) If i_num is non-numeric;

3) If suffix is neither "i" nor "j"