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

How to use the <span class='notranslate'>COMPLEX</span> 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 <span class='notranslate'>COMPLEX</span> 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