How to Use the IMABS, IMARGUMENT, and IMCONJUGATE Functions in Microsoft Excel

Working with complex numbers in engineering, electrical impedance analysis, fluid dynamics, and physics calculations frequently requires converting between Cartesian rectangular format ($x + yi$) and polar coordinates ($r\angle\theta$). Microsoft Excel provides three specialized engineering functions—IMABS, IMARGUMENT, and IMCONJUGATE—to calculate the absolute modulus, polar phase angle (argument), and complex conjugate directly from complex string representations.

Overview of Complex Coordinate Functions in Excel

Complex numbers in Excel are treated as text strings formatted as "x+yi" or "x+yj". Because standard mathematical operators cannot evaluate text strings directly, Excel includes native functions to extract magnitude and phase without requiring manual parsing of real and imaginary coefficients:

Function	Mathematical Operation	Output Type	Core Application
IMABS(inumber)	Modulus / Magnitude: $\sqrt{x^2 + y^2}$	Real Number	Impedance magnitude, signal amplitude, vector length.
IMARGUMENT(inumber)	Phase Angle ($\theta$ in radians): $\arctan(y / x)$	Real Number ($-\pi < \theta \le \pi$)	Phase shift, power factor angles, oscillation lag.
IMCONJUGATE(inumber)	Complex Conjugate: $x – yi$	Complex String ("x-yi")	Complex division rationalisation, conjugate matching.

1. Using IMABS to Calculate Complex Modulus

The IMABS function calculates the absolute value (or modulus) of a complex number, measuring the linear distance from the origin on the complex Argand plane to the coordinates $(x, y)$.

Syntax and Parameters

=IMABS(inumber)

Where inumber is a valid complex number string or a cell reference containing one (such as "3+4i").

Practical Example

To find the absolute magnitude of a circuit impedance vector $Z = 3 + 4j$ ohms entered in cell A2:

=IMABS(A2)

Result: 5 ($\sqrt{3^2 + 4^2} = \sqrt{25} = 5$).

2. Using IMARGUMENT to Calculate the Phase Angle (Theta)

The IMARGUMENT function returns the phase angle $\theta$, expressed in radians, where $-\pi < \theta \le +\pi$.

Syntax and Parameters

=IMARGUMENT(inumber)

Converting Radians to Degrees

Because engineers typically evaluate phase angles in degrees rather than radians, wrap the IMARGUMENT formula inside Excel’s native DEGREES function:

=DEGREES(IMARGUMENT("3+4i"))

Result: 53.13010235 degrees.

Complex Number	Quadrant	IMARGUMENT (Radians)	Angle in Degrees (DEGREES)
"1+1i"	Quadrant I	0.785398	45.0°
"-1+1i"	Quadrant II	2.356194	135.0°
"-1-1i"	Quadrant III	-2.356194	-135.0°
"1-1i"	Quadrant IV	-0.785398	-45.0°

3. Using IMCONJUGATE to Invert the Imaginary Component

The complex conjugate of a number reverses the sign of the imaginary coefficient ($x + yi$ becomes $x – yi$, and vice versa). Conjugate multiplication is essential when rationalising complex fractions or determining maximum power transfer in AC network analysis.

Syntax and Parameters

=IMCONJUGATE(inumber)

Practical Examples

• =IMCONJUGATE("4+7i") returns "4-7i".
• =IMCONJUGATE("12-5j") returns "12+5j".
• =IMCONJUGATE("8") returns "8" (purely real numbers remain unchanged).
• =IMCONJUGATE("3i") returns "-3i".

Constructing Polar Form from Rectangular Inputs

You can combine these functions with the COMPLEX function and standard string concatenation to convert any rectangular Cartesian vector into an informative polar notation string:

=ROUND(IMABS(A2), 2) & " ∠ " & ROUND(DEGREES(IMARGUMENT(A2)), 1) & "°"

If cell A2 holds "5+12i", this formula produces "13 ∠ 67.4°".

Troubleshooting Common Errors

• #NUM! Error: Occurs if inumber is 0 or "0" when evaluated by IMARGUMENT, as the phase angle of the origin is mathematically undefined.
• #VALUE! Error: Returned if the input string contains invalid syntax (e.g., spaces inside the complex string like "3 + 4i" or using capital "I" or "J" instead of lowercase).
• Inconsistent Suffixes: While Excel supports both i and j, do not mix suffixes within the same calculation or nested function call.