Documentation/Calc Functions/IMPRODUCT

Function name:
IMPRODUCT

Category:
Add-in

Summary:
Calculates the product of multiple complex numbers.

Syntax:
IMPRODUCT(Complex 1 [; Complex 2 [; … [; Complex 255]]])

Returns:
Returns a text string giving the complex number that results from multiplying together the complex numbers passed as arguments.

Arguments:
Complex 1 is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to one or more cells containing such strings, which are the complex numbers to be multiplied together. a and b are real numbers.

Complex 2 ... Complex 255 are as Complex 1.


 * If any of the complex numbers passed to IMPRODUCT does not have an imaginary part (b equal to 0), the real part can be passed to IMPRODUCT as a number rather than a string.
 * If any of the strings passed to IMPRODUCT is not a valid complex number, or any of the referenced cells contain an invalid complex number, IMPRODUCT reports an invalid argument error (Err:502).
 * It is possible for the arguments passed to IMPRODUCT to contain no complex numbers. In this case IMPRODUCT returns 0.
 * If the complex numbers passed to IMPRODUCT use different imaginary units (i or j), IMPRODUCT returns the result using the imaginary unit of the first complex number processed.

Details specific to IMPRODUCT function
For two complex numbers of the form a+bi and c+di, IMPRODUCT implements the following equation: The equation is applied repeatedly depending how many complex numbers are specified in the arguments.

Related LibreOffice functions:
IMDIV

IMSUB

IMSUM

ODF standard:
Section 6.8.18, part 2

Equivalent Excel functions:
IMPRODUCT