[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

IMDIV

Syntax:

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

text

Complex numbers in x + yi or x + yj text format; they designate the dividend and divisor, respectively.

complex-number-2

text

 

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]