IMARGUMENT in Excel: Find Complex Phase with the Correct Quadrant

• Introduced: the first introduction version is not established by the reviewed official history.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official IMARGUMENT reference. Documentation and independent models; no native Excel execution or wider platform certification.

=IMARGUMENT(inumber)

Inumber is required. Microsoft defines the complex value through its magnitude and angle, and its equation image gives the principal angle interval (−pi,pi]. The zero complex value has no mathematical direction; the dedicated page does not establish its native error behavior.

Another equation image abbreviates the angle as inverse tangent of y/x. That expression needs quadrant handling: the ratio alone cannot distinguish opposite directions. Do not replace IMARGUMENT with a plain ATAN of the quotient for every input.

For an independent Excel check, ATAN2 takes the x coordinate first and the y coordinate second. Use the real coefficient as x and the imaginary coefficient as y. This argument order is product-specific and should not be copied from a programming language without checking.

Enter only the first column as text in A2:A5. In B2 use =IMARGUMENT(A2) and in C2 use =DEGREES(B2), filling both down. Displayed results below are rounded to nine decimal places.

The first and third values have the same ratio y/x, but point in opposite directions. A plain inverse tangent of that ratio cannot distinguish them.

DEGREES changes the angular unit. It does not alter which direction is being represented. Keep the unit visible in column headings to prevent using a degree value in a radians-based calculation.

Under the documented principal-angle model, 0+2i has angle pi/2, −2+0i has angle pi, and 0−2i has angle −pi/2. These correspond to 90, 180 and −90 degrees.

Use =IMARGUMENT("0+2i"), =IMARGUMENT("-2+0i") and =IMARGUMENT("0-2i") as independently modeled controls. The negative real axis uses the included endpoint pi rather than the excluded −pi.

Do not assign an arbitrary direction to the zero complex value. Its magnitude is zero and every direction would describe the same point; a native error code or signed-zero convention is not certified by this guide.

For the first fixture, put this formula in D2 and fill down:

=ATAN2(IMREAL(A2),IMAGINARY(A2))

It has the same independently expected four angles as column B. The arguments are real then imaginary, matching Excel’s x-first ATAN2 contract.

For 4+3i, reversing them would instead produce approximately 0.927295218 radians, or 53.130102354 degrees. That angle belongs to coordinates (3,4), not (4,3). A plausible-looking positive angle can therefore still use the wrong coordinate order.

For 4+3i, IMABS returns magnitude five. If that magnitude is in E2 and its IMARGUMENT angle is in F2, reconstruct numeric components with:

=E2*COS(F2)
=E2*SIN(F2)

The mathematical outputs are four and three. Feed the two coefficients to COMPLEX if a complex representation is required again.

Because the angle is irrational, independently rounded display values are not exact substitutes for the original numeric angle. Use the formula result in F2 rather than retyping the nine-decimal display when checking reconstruction.

Suppose two directions are 170 degrees and −170 degrees. Ordinary subtraction of the latter minus the former gives −340 degrees, even though the shorter signed change is positive 20 degrees.

For degree values in H2 and I2, =MOD(I2-H2+180,360)-180 wraps the difference into [−180,180). With 170 and −170 it returns 20. This reporting interval is deliberately different at the 180-degree endpoint from IMARGUMENT’s (−180,180] convention.

The wrap formula is an independent arithmetic policy for differences, not a change to the function’s documented principal branch. Choose and label a convention before combining phase reports.

The product of 4+3i and 1+i is 1+7i. Its principal angle is approximately 1.428899272 radians, equal here to 0.643501109 plus pi/4 before display rounding. Other products may require wrapping the angle sum back into the principal interval.

Malformed input, exact signed-zero parsing and native boundary errors remain unverified. All angles and reconstruction checks were independently calculated; no native Excel execution was performed.

• Microsoft IMARGUMENT reference.
• Editorial testing standards.

Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.