Author: Oscar Cronquist Article last updated on September 23, 2022

How to use the COMPLEX functionv2

The COMPLEX function returns a complex number based on a real and imaginary number.

1. COMPLEX Function Syntax

COMPLEX(real_num, i_num, [suffix])

Back to top

2. COMPLEX Function Arguments

real_num Required. The real coefficient of the complex number.
i_num Required. The imaginary coefficient of the complex number.
[suffix] Optional. This argument lets you choose the suffix of the imaginary component. The default value is "i".

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

The COMPLEX function returns #VALUE if the suffix is not "i", "j" or omitted.

Back to top

3. COMPLEX Function example

How to use the COMPLEX functionv2

Cell B3 contains the real coefficient of the complex number, x in the diagram. Cell C3 contains the imaginary coefficient of the complex number, y in the diagram shown above.

Cell E3 calculates the complex number based on the real and imaginary coefficients specified in cells B3 and C3 respectively.

Formula in cell E3:

=COMPLEX(B3,C3)

3.1 Explaining formula

Step 1 - Populate arguments

COMPLEX(real_num, i_num, [suffix])

becomes

COMPLEX(B3,C3)

Step 2 - Evaluate COMPLEX function

COMPLEX(B3,C3)

becomes

COMPLEX(2,3)

and returns

"2+3i".

Back to top