Work with complex numbers: arithmetic, powers, roots and trigonometry. This page lists all 26 of them; each links to a full lesson with an example you can copy and a practice file.
COMPLEXCOMPLEX builds a complex number like 3+4i from its real and imaginary parts, as text that the IM……IMABSIMABS returns |z|, the length of the vector: SQRT(a²+b²). For impedance it's the magnitude in ohms. Complex numbers…IMAGINARYIMAGINARY returns the imaginary coefficient b of a+bi. Complex numbers are text like 3+4i; build them with COMPLEX.IMARGUMENTIMARGUMENT returns the angle θ in radians (phase angle). Complex numbers are text like 3+4i; build them with…IMCONJUGATEIMCONJUGATE returns a-bi. Complex numbers are text like 3+4i; build them with COMPLEX.IMCOSIMCOS returns cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMCOSHIMCOSH returns cosh(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMCOTIMCOT returns 1/tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMCSCIMCSC returns 1/sin(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMCSCHIMCSCH returns 1/sinh(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMDIVIMDIV divides one complex number by another, e.g. current = voltage / impedance.IMEXPIMEXP returns e^z. Complex numbers are text like 3+4i; build them with COMPLEX.IMLNIMLN returns ln(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMLOG10IMLOG10 returns log10(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMLOG2IMLOG2 returns log2(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMPOWERIMPOWER raises a complex number to a power.IMPRODUCTIMPRODUCT multiplies complex numbers, e.g. voltage = current x impedance.IMREALIMREAL returns the real coefficient a of a+bi. Complex numbers are text like 3+4i; build them with COMPLEX.IMSECIMSEC returns 1/cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMSECHIMSECH returns 1/cosh(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMSINIMSIN returns sin(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMSINHIMSINH returns sinh(z). Complex numbers are text like 3+4i; build them with COMPLEX.IMSQRTIMSQRT returns the principal square root. Complex numbers are text like 3+4i; build them with COMPLEX.IMSUBIMSUB subtracts one complex number from another.IMSUMIMSUM adds complex numbers: (3+4i)+(1-i) = 4+3i. Impedances in series add.IMTANIMTAN returns tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.