Documentation/Calc Functions/IMSUB

Function name:
IMSUB

Category:
Add-in

Summary:
Calculates the result of subtracting one complex number from another.

Syntax:
IMSUB(ComplexNumber1; ComplexNumber2)

Returns:
Returns a text string giving the complex number that results when subtracting one complex number from another.

Arguments:
ComplexNumber1 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 minuend of the subtraction operation. a and b are real numbers.

ComplexNumber2 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 subtrahend of the subtraction operation. a and b are real numbers.


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

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

Related LibreOffice functions:
IMDIV

IMPRODUCT

IMSUM

ODF standard:
Section 6.8.25, part 2

Equivalent Excel functions:
IMSUB