COMPLEX Function in Excel: Build a Complex Number
COMPLEX builds a complex number like 3+4i from its real and imaginary parts, as text that the IM… functions understand. Used in AC circuits…
Read article →Engineering
Excel Engineering functions explained with syntax, examples and common mistakes.
💬
← Excel
Engineering
Excel Engineering functions explained with syntax, examples and common mistakes.
📄 54 articles⬇️ 12 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →IMPRODUCT Function in Excel: Multiply Complex Numbers
IMPRODUCT Function in Excel: Multiply Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMPRODUCT multiplies complex numbers, e.g. voltage = current x impedance.Syntax=IMPRODUCT(inumber1.
Read article →IMAGINARY Function in Excel: Imaginary Part
IMAGINARY Function in Excel: Imaginary Part
IMAGINARY returns the imaginary coefficient b of a+bi. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT Function in Excel: Square Root of a Complex Number
IMSQRT returns the principal square root. Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSUB Function in Excel: Subtract Complex Numbers
IMSUB Function in Excel: Subtract Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUB subtracts one complex number from another.Syntax=IMSUB(inumber1, inumber2)ArgumentWhat it.
Read article →IMSEC Function in Excel: Secant of a Complex Number
IMSEC Function in Excel: Secant of a Complex Number
IMSEC returns 1/cos(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 Function in Excel: Base-2 Log of a Complex Number
IMLOG2 returns log2(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMPOWER Function in Excel: Complex Number to a Power
IMPOWER Function in Excel: Complex Number to a Power
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMPOWER raises a complex number to a power.Syntax=IMPOWER(inumber, number)ArgumentWhat it.
Read article →IMTAN Function in Excel: Tangent of a Complex Number
IMTAN Function in Excel: Tangent of a Complex Number
IMTAN returns tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.
Read article →IMSUM Function in Excel: Add Complex Numbers
IMSUM Function in Excel: Add Complex Numbers
Complex numbersLevel: ExpertAvailable in: Excel 2007+IMSUM adds complex numbers: (3+4i)+(1-i) = 4+3i. Impedances in series add.Syntax=IMSUM(inumber1.
Read article →IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS returns |z|, the length of the vector: SQRT(a²+b²). For impedance it's the magnitude in ohms. Complex numbers are text like 3+4i; build them…
Read article →ERF.PRECISE Function in Excel: Error Function (2010+ Version)
ERF.PRECISE Function in Excel: Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERF.PRECISE is the 2010 version of ERF with one argument.Syntax=ERF.PRECISE(x)ArgumentWhat it.
Read article →