[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
IMDIV ( complex-number-1 , complex-number-2 )
Description: Computes the quotient from dividing two complex numbers.
Mathematical Formula:
Arguments:
Name |
Type |
Description |
complex-number-1 |
Complex numbers in x + yi or x + yj text format; they designate the dividend and divisor, respectively. | |
complex-number-2 |
Return Type and Value: text – A string containing the quotient from number-1 / number-2, in x+yi or x+yj text format.
However, if complex-number-1 or complex-number-2 is ill-formed, #NUM! is returned.
[Example:
IMDIV("13+4i","5+3i") results in 2.26470588235294-0.558823529411765i
IMDIV("-3-3.5i","5+3i") results in -0.75-0.25i
end example]