Engineering functions arithmetic operations of complex numbers
Excel Function IMDIV
The IMDIV() function is used to calculate the quotient of two complex numbers.
This function takes two complex numbers as its arguments.
The first parameter is the dividend and the second parameter is the divisor.
Complex Number1 | Complex Number2 | IMDIV |
2+5i | 6+5.7i | 0.591327201051248+0.271572492334647i |
4+2.3i | 1.4+8i | 0.363856882959369-0.43632504548211i |
6+5.7i | 1.7+11i | 0.588425215917346-0.454516102994592i |
1.4+8i | 2+5i | 1.47586206896552+0.310344827586207i |
1.7+11i | 4+2.3i | 1.50775011742602+1.88304368248004i |
Excel Function IMPRODUCT
The IMPRODUCT() function is used to determine the product of two complex numbers.
This function takes two complex numbers as its arguments.
Complex Number1 | Complex Number2 | IMPRODUCT |
2+5i | 6+5.7i | -16.5+41.4i |
4+2.3i | 1.4+8i | -12.8+35.22i |
6+5.7i | 1.7+11i | -52.5+75.69i |
1.4+8i | 2+5i | -37.2+23i |
1.7+11i | 4+2.3i | -18.5+47.91i |
Excel Function IMSUM
The IMSUM() function is used to calculate the sum of two complex numbers.
This function also takes two complex numbers as its parameters.
Complex Number1 | Complex Number2 | IMSUM |
2+5i | 6+5.7i | 8+10.7i |
4+2.3i | 1.4+8i | 5.4+10.3i |
6+5.7i | 1.7+11i | 7.7+16.7i |
1.4+8i | 2+5i | 3.4+13i |
1.7+11i | 4+2.3i | 5.7+13.3i |
Excel Function IMSUB
The IMSUB() function is used to calculate the difference between two complex numbers.
This function takes two complex numbers as its parameters.
The real part and imaginary part are calculated independently.
Complex Number1 | Complex Number2 | IMSUB |
2+5i | 6+5.7i | -4-0.7i |
4+2.3i | 1.4+8i | 2.6-5.7i |
6+5.7i | 1.7+11i | 4.3-5.3i |
1.4+8i | 2+5i | -0.6+3i |
1.7+11i | 4+2.3i | -2.3+8.7i |
Excel Function IMSQRT
The IMSQRT() function is used to calculate the square root of the complex number.
This function takes one parameter which is a complex number.
Complex Number2 | IMSQRT |
6+5.7i | 2.67169127468728+1.06674001858003i |
1.4+8i | 2.1819230281679+1.83324523750899i |
1.7+11i | 2.53284311436705+2.17147282782828i |
2+5i | 1.9216093264676+1.30099285300391i |
4+2.3i | 2.07534440491497+0.55412489477722i |