Documentation/Calc Functions/IMSUM

Function name:
IMSUM

Category:
Add-in

Summary:
Calculates the sum of multiple complex numbers.

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

Returns:
Returns a text string giving the complex number that results from adding 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 added together. a and b are real numbers.

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


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

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

Related LibreOffice functions:
IMDIV

IMPRODUCT

IMSUB

ODF standard:
Section 6.8.26, part 2

Equivalent Excel functions:
IMSUM