ExcelFlux

IMPRODUCT function

the product of complex numbers.

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

Multiply complex values. The square of i is −1.

A worked example from the workbook

RowAB
6First valueSecond value
71+i1-i
8ii
923
Record 1
=IMPRODUCT(A7,B7)

Expected result2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=IMPRODUCT("1+i","1-i")
Turkish Excel · tr-TR
=SANÇARP("1+i";"1-i")

Expected result

“2”

Worked examples

Multiply complex values. The square of i is −1.

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 1+i 1-i
8 i i
9 2 3
Case Formula Expected result
Record 1 =IMPRODUCT(A7,B7) 2
Record 2 =IMPRODUCT(A8,B8) -1
Record 3 =IMPRODUCT(A9,B9) 6
Microsoft Excel reference