IMPRODUCT

Formulas / IMPRODUCT
Multiply complex numbers and return the result as a complex number.
IMPRODUCT(inumber1, inumber2, ...)
  • inumber1 - required argument
  • inumber2 - [OPTIONAL] additional argument

Examples

  • =IMPRODUCT("3+4i","5-3i")

    The function can be used to calculate the product of two complex numbers. For example, this formula calculates the product of 3+4i and 5-3i. The result of this calculation is 27+11i.

  • =IMPRODUCT(A1,B1)

    Another example of the function is to calculate the product of two complex numbers in the form of cell references. For example, if cell A1 contains the value "3+4i" and cell B1 contains the value "5-3i", the above formula can be used.The result of this calculation is also 27+11i.

  • =IMPRODUCT("3+4i","5-3i","4+2i")

    The function can also be used to calculate the product of multiple complex numbers. For example, the preceding formula calculates the product of 3+4i, 5-3i, and 4+2i. The result of this calculation is -360+370i.

Summary

The IMPRODUCT function is used to multiply complex numbers by taking a set of complex numbers as arguments.

  • The IMPRODUCT function returns the product of one or more complex numbers, up to a total of 255 numbers.
  • The complex numbers must be in the form of x + yi or x + yj.


Frequently Asked Questions

What is the IMPRODUCT Function?
The IMPRODUCT function is a Sourcetable function that multiplies complex numbers. It takes a set of complex numbers as arguments and returns a complex number as its output.
What Format Does the Output Come In?
The complex number is formatted using x + yi or x + yj.
What Are Examples of Complex Numbers?
Examples of complex numbers include:
  • 3 + 2i
  • 6 + 5j
  • 2 - 4i
  • 9 - 3j
  • 7i
  • -5j

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV