IMPRODUCT

Excel Functions

Get product of complex numbers

Syntax

EXCEL

=IMPRODUCT(inumber1, [inumber2], ...)

Arguments

Parameter	Description
`inumber1`	Complex number 1.
`inumber2`	[optional] Complex number 2.

Return Value

Product as complex number

Details

The Excel IMPRODUCT function returns the product of one or more complex numbers. For example: The IMPRODUCT function takes in two or more arguments in the form of inumber1, inumber2, and so on. Arguments can be hard-coded values, cell references, or a range. To calculate the product of multiple complex numbers in a range, use the function like this: If Excel encounters values not recognized as complex numbers, a #NUM! Error is thrown. The product of two complex numbers is visualized by transforming the coordinate system according to one of the numbers and drawing the second number using the transformed coordinate system. For example, the product of "1+2i" and "3+5i" is visualized by transforming the coordinate system (shown in blue) so that one (drawn as the green arrow) goes to the number

Examples

Example 1

The Excel IMPRODUCT function returns the product of one or more complex numbers. For example:

EXCEL

=IMPRODUCT("1+2i", "3+5i") // returns -7+11i

Examples

The IMPRODUCT function takes in two or more arguments in the form of inumber1, inumber2, and so on. Arguments can be hard-coded values, cell reference

EXCEL

=IMPRODUCT(B6:B10) // multiply the complex numbers in B6:B10

Examples

If Excel encounters values not recognized as complex numbers, a #NUM! Error is thrown.

EXCEL

=IMPRODUCT("1+2i", "invalid input") // throws #NUM! error

Explanation

EXCEL

=IMPRODUCT("1+2i", "3+5i") // returns -7+11i

IMPRODUCT

Syntax

Arguments

Return Value

Details

Examples

See Also