Resources on Complex Number

Microsoft Excel has many functions related to complex number:

COMPLEX(a,b,"j") = return a complex number A=a+bj
IMABS(A) = modulus of a complex number A, |A|
IMAGINARY(A) = imaginary coefficient of a complex number A, Im(A)
IMARGUMENT(A) = angle argument of a complex number A in radian, arg(A)
IMCONJUGATE(A) = complex conjugate of a complex number A, A*
IMCOS(A) = the cosine of a complex number A, Cos(A)
IMDIV(A,B) = division of two complex numbers A/B
IMEXP(A) = the exponential of a complex number A, exp(A)
IMLN(A) = the natural logarithm of a complex number A, Ln(A)
IMLOG10 = the log base-10 of a complex number A, Log10(A)
IMLOG2= the log base-2 of a complex number A, Log2(A)
IMPOWER(A,n) = complex power of A^n
IMPRODUCT(A,B) = Complex multiplication A.B
IMREAL(A) = real coefficient of a complex number A, Re(A)
IMSIN(A) = the sine of a complex number A, Sin(A)
IMSQRT(A) = square root of a complex number A, Sqrt(A)
IMSUB(A,B) = complex subtraction A-B
IMSUM(A,B) = complex addition A+B

Examples
=COMPLEX(2,3,"j") produces 2+3j
=IMABS("1+j") produces 1.4142 (the modulus of A=(1,1) is square root of 2)
=IMAGINARY("2+3j") produces 3
=DEGREES(IMARGUMENT("1+j")) produces 45
=IMCONJUGATE("2+3j") produces 2-3j
=IMPRODUCT("1+j","2+3j") produces -1+5j
=IMCOS("1+j") produces 0.833730025131149-0.988897705762865j

< Next | Previous | Index >

Rate this tutorial or give your comments about this tutorial