Documentation/Calc Functions/IMDIV

Function name:
IMDIV

Category:
Add-in

Summary:
Calculates the result of dividing one complex number by another.

Syntax:
IMDIV(Numerator; Denominator)

Returns:
Returns a text string giving the complex number that results from dividing one complex number by another.

Arguments:
Numerator is a string (in quotation marks) representing a complex number in the form a+bi or a+bj, or a reference to a cell containing that string, which is the numerator or dividend of the division operation.

Denominator is a string (in quotation marks) representing a complex number in the form c+di or c+dj, or a reference to a cell containing that string, which is the denominator or divisor of the division operation.


 * If either Numerator or Denominator does not have an imaginary part (b or d equal to 0), that argument’s real part can be passed to IMDIV as a number rather than a string.
 * If both real and imaginary parts of Denominator are 0, IMDIV reports an invalid argument error (Err:502).
 * If either Numerator or Denominator is not a valid complex number, IMDIV reports an invalid argument error (Err:502).
 * If Numerator and Denominator use different imaginary units (i or j), IMDIV returns the result using the imaginary unit of Numerator.

Details specific to IMDIV function
For complex numbers of the form a+bi and c+di, IMDIV implements the following equation:

Related LibreOffice functions:
IMPRODUCT

IMSUB

IMSUM

ODF standard:
Section 6.8.12, part 2

Equivalent Excel functions:
IMDIV