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: 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)