Engineering functions arithmetic operations of complex numbers

Excel Function COMPLEX

The COMPLEX() function takes real and imaginary coefficients and converts them to a complex number.

The complex number so formed is of the form X+iY.

The third parameter of the function describes the suffix to be used; either "I" or "j".

The default suffix is "I".

Real Part Imaginary Part COMPLEX() default suffix COMPLEX() with "j" Formula
2 5 2+5i 2+5j =COMPLEX(L4,M4,"j")
4 2.3 4+2.3i 4+2.3j =COMPLEX(L5,M5,"j")
6 5.7 6+5.7i 6+5.7j =COMPLEX(L6,M6,"j")
1.4 8 1.4+8i 1.4+8j =COMPLEX(L7,M7,"j")
1.7 11 1.7+11i 1.7+11j =COMPLEX(L8,M8,"j")

 

 

Excel Function IMABS

The IMABS() function is used to determine the absolute value of a complex number.

The absolute value is also called as modulus.

It is nothing but the square root of sum of square of imaginary part and square of real part.

For example, for a complex number a+ib, the absolute value is determined as below:

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

Complex number IMABS Formula
2+5i 5.3851648071345 =IMABS(L18)
4+2.3i 4.61410879802373 =IMABS(L19)
6+5.7i 8.27586853448023 =IMABS(L20)
1.4+8i 8.12157620169878 =IMABS(L21)
1.7+11i 11.1305884839931 =IMABS(L22)

 

 

Excel Function IMAGINARY

The IMAGINARY() function is used to determine the imaginary coefficient of the complex number.

This function does not return the suffix "I" or "j" and only returns the number.

The complex numbers are always treated as text and hence should be specified as a string within the function.

Complex number IMAGINARY Formula
2+5i 5 =IMAGINARY(L33)
4-2.3i -2.3 =IMAGINARY(L34)
6+5.7i 5.7 =IMAGINARY(L35)
1.4-8i -8 =IMAGINARY(L36)
1.7+11i 11 =IMAGINARY(L37)

 

 

Excel Function IMARGUMENT

A complex number can also be expressed in terms of angle in radians.

The IMARGUMENT() function is useful in such scenario where the angle in radians is to be determined.

This function takes the complex number in normal form as its parameter.

Complex number IMARGUMENT Formula
2+5i 1.19028994968253 =IMARGUMENT(L46)
4-2.3i -0.52183427981441 =IMARGUMENT(L47)
6+5.7i 0.759762754875771 =IMARGUMENT(L48)
1.4-8i -1.39755066034253 =IMARGUMENT(L49)
1.7+11i 1.41746393839657 =IMARGUMENT(L50)

 

 

Excel Function IMCONJUGATE

The IMCONJUGATE() function is used to determine the complex conjugate of the given complex number.

The complex conjugate is determined by inversing the sign of the imaginary number.

This function is most often used in signal processing problems.

Complex number IMCONJUGATE Formula
2+5i 2-5i =IMCONJUGATE(L59)
4-2.3i 4+2.3i =IMCONJUGATE(L60)
6+5.7i 6-5.7i =IMCONJUGATE(L61)
1.4-8i 1.4+8i =IMCONJUGATE(L62)
1.7+11i 1.7-11i =IMCONJUGATE(L63)

 

 

Excel Function IMREAL

The IMREAL() function is used to determine the real part of the complex number.

The real part, if negative, is returned as a negative number.

This function takes a single complex number as its argument.

Complex number IMREAL Formula
2+5i 2 =IMREAL(L72)
4-2.3i 4 =IMREAL(L73)
6+5.7i 6 =IMREAL(L74)
1.4-8i 1.4 =IMREAL(L75)
1.7+11i 1.7 =IMREAL(L76)

 

You can find similar Excel Questions and Answer hereunder

1) engineering functions trignometric functions of complex numbers imsinh imcosh imcsch imsech

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

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

4) Vba to return week numbers in Excel

5) engineering functions bessel functions besseli besselj besselk bessely

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

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

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

9) engineering functions arithmetic operations of complex numbers imdiv improduct imsum imsub imsqrt

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

 

Here the previous and next chapter