Excel Made Easy

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

 

You can find similar Excel Questions and Answer hereunder

1) How can I calculate values applying complex Engineering formulas using Excel?

2) engineering functions arithmetic operations of complex numbers complex imabs imaginary imargument imconjugate imreal

3) engineering functions number conversions octal and hexadecimal oct2bin oct2dec oct2hex hex2bin hex2dec hex2oct

4) How can I add a Prefix to a set of numbers in a range?

5) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

6) engineering functions bessel functions besseli besselj besselk bessely

7) engineering functions comparison and error functions convert delta erf erfc gestep

8) engineering functions number conversions binary and decimal bin2dec bin2oct bin2hex dec2bin dec2oct dec2hex

9) Converting numbers stored as text to numbers via macro in Excel

10) engineering functions trignometric functions of complex numbers imsin imcos imtan imcsc imsec imcot

 

Here the previous and next chapter

Excel Made Easy was founded in 2002. Excel Made Easy is a service to people looking to learn Microsoft Excel or any other spreadsheet SW on the market.

We endeavor to provide the best service and support and to respond quickly to your questions.

Excel Made Easy is a proud sponsor of Dismantle-It.com the site that shows you the belly of your daily objects, Poupounette.com the site of cars loving cat and PowerPointMadeEasy.com the world top reference for PowerPoint Presentations questions and Pet Cemetery Online a site dedicated to your loving Pets.