IMDIV
Formulas / IMDIVDivide complex numbers.
=IMDIV(inumber1, inumber2)
- inumber1 - required, complex numerator or dividend
- inumber2 - required, complex denominator or divisor
Examples
=IMDIV("2+2i", "2+i")The IMDIV function can be used to divide two complex numbers. For example, 2+2i by 2+i, and this returns the complex number 2+2i.
=IMDIV( COMPLEX( 5, 2 ), COMPLEX( 0, 1 ) )The IMDIV function can also be used with the COMPLEX function. For example, 5+2i by 2+1i, and this returns the complex number 5+2i divided by 2+1i.
Need help with Formulas?
Summary
The IMDIV function is used to calculate the quotient of two complex numbers. It takes two complex numbers as arguments and divides one by the other.
- The IMDIV function is used to divide complex numbers.
- IMDIV uses an imaginary number as the divisor.
Frequently Asked Questions
What is the IMDIV function?
The IMDIV function is a function used to calculate the quotient of two complex numbers. The syntax for the function is IMDIV(number1, number2).
What are the arguments for the IMDIV function?
The IMDIV function requires two arguments:
- number1: This is the complex numerator or dividend.
- number2: This is the complex denominator or divisor.
What is the output of the IMDIV function?
The IMDIV function returns a complex number in text format.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV