ExcelFlux

COMPLEX function

Conversion — real and imaginary coefficients into a complex number.

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Combine real and imaginary measurements into Excel’s complex-number representation.

A worked example from the workbook

RowAB
6First valueSecond value
734
81-2
905
Record 1
=COMPLEX(A7,B7)

Expected result3+4i

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=COMPLEX(3,4)
Turkish Excel · tr-TR
=KARMAŞIK(3;4)

Expected result

“3+4i”

Worked examples

Combine real and imaginary measurements into Excel’s complex-number representation.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 3 4
8 1 -2
9 0 5
Case Formula Expected result
Record 1 =COMPLEX(A7,B7) 3+4i
Record 2 =COMPLEX(A8,B8) 1-2i
Record 3 =COMPLEX(A9,B9) 5i
Microsoft Excel reference