IMDIV function for Sheets

1 min read
I. Intro
The IMDIV function is commonly used to divide one complex number by another. The two complex numbers are represented by x+yi and x+yj in this article.
II. About the function
  • Formula: =IMDIV(dividend,divisor)
  • Arguments:
  • dividend (required): The complex number to be divided.
  • divisor (required): The complex number that divides the other.
Note:
  • The COMPLEX function can be used convert real and imaginary coefficients into a complex number.
  • The quotient of two complex numbers is shown below. The IMDIV function can be used to calculate the result.
250px|700px|reset
III. Steps
Use the function
  1. Select a cell and enter = IMDIV, or click Formulas on the toolbar. Select Engineering, then select the IMDIV function.
  1. Enter the arguments =IMDIV(A2,B2) into the cell.
  1. Press Enter to get the result, which is 1.4+0.2i.
250px|700px|reset
Delete the function
Select the cell with the IMDIV function, and press Delete.
Written by: Feishu Help Center
Updated on 2024/12/09
Was this content helpful?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom