How to Use the IMPRODUCT Function in Excel

Here you will find a comprehensive guide on utilizing the IMPRODUCT function in Microsoft Excel and Google Sheets.

Overview

The IMPRODUCT function is designed to multiply complex numbers. A complex number is any number that can be represented in the format a + bi, where “a” and “b” are real numbers, and “i” represents the imaginary unit, the square root of -1.

Syntax

The IMPRODUCT function follows the same syntax in both Excel and Google Sheets:

=IMPRODUCT(inumber1, [inumber2], ...)
  • inumber1: The first complex number or a cell range containing complex numbers that will be multiplied.
  • inumber2 (optional): Additional complex numbers that are to be multiplied. You can include as many additional complex numbers as required.

Examples

Below are several examples to illustrate how the IMPRODUCT function can be used effectively.

Example 1: Multiply Two Complex Numbers

Consider two complex numbers located in cells A1 and B1. To multiply these numbers, employ the formula:

=IMPRODUCT(A1, B1)

Example 2: Multiply Multiple Complex Numbers

To multiply three complex numbers situated in cells A1, B1, and C1, the formula would be:

=IMPRODUCT(A1, B1, C1)

Example 3: Using Constant Values

It’s also possible to directly input complex number constants into your formula. For example, to multiply the complex numbers 2+3i and 4+2i, you would write:

=IMPRODUCT("2+3i", "4+2i")

Notes

  • If any argument is not recognized as a valid complex number, the IMPRODUCT function will return a #NUM! error.
  • The outcome of the IMPRODUCT function remains a complex number.

Utilizing the syntax and examples provided, you can adeptly apply the IMPRODUCT function in both Microsoft Excel and Google Sheets to handle multiplication of complex numbers.

More information: https://support.microsoft.com/en-us/office/improduct-function-2fb8651a-a4f2-444f-975e-8ba7aab3a5ba

Other functions
Returns the modified Bessel function In(x)
Returns the Bessel function Jn(x)
Returns the modified Bessel function Kn(x)
Returns the Bessel function Yn(x)
Converts a binary number to decimal
Converts a binary number to hexadecimal
Converts a binary number to octal
Returns a 'Bitwise And' of two numbers
Returns a value number shifted left by shift_amount bits
Returns a bitwise OR of 2 numbers
Returns a value number shifted right by shift_amount bits
Returns a bitwise 'Exclusive Or' of two numbers
Converts real and imaginary coefficients into a complex number
Converts a number from one measurement system to another
Converts a decimal number to binary
Converts a decimal number to hexadecimal
Converts a decimal number to octal
Tests whether two values are equal
Returns the error function
Returns the error function
Returns the complementary error function
Returns the complementary ERF function integrated between x and infinity
Tests whether a number is greater than a threshold value
Converts a hexadecimal number to binary
Converts a hexadecimal number to decimal
Converts a hexadecimal number to octal
Returns the absolute value (modulus) of a complex number
Returns the imaginary coefficient of a complex number
Returns the argument theta, an angle expressed in radians
Returns the complex conjugate of a complex number
Returns the cosine of a complex number
Returns the hyperbolic cosine of a complex number
Returns the cotangent of a complex number
Returns the cosecant of a complex number
Returns the hyperbolic cosecant of a complex number
Returns the quotient of two complex numbers
Returns the exponential of a complex number
Returns the natural logarithm of a complex number
Returns the base-10 logarithm of a complex number
Returns the base-2 logarithm of a complex number
Returns a complex number raised to an integer power
Returns the real coefficient of a complex number
Returns the secant of a complex number
Returns the hyperbolic secant of a complex number
Returns the sine of a complex number
Returns the hyperbolic sine of a complex number
Returns the square root of a complex number
Returns the difference between two complex numbers
Returns the sum of complex numbers
Returns the tangent of a complex number
Converts an octal number to binary
Converts an octal number to decimal
Converts an octal number to hexadecimal