[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]