IMABS in Excel: Measure Complex Magnitude and Avoid Component Sums

• 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 IMABS reference. Documentation and independent models; no native Excel execution or wider platform certification.

=IMABS(inumber)

Inumber is required and uses complex i or j notation. Microsoft illustrates the magnitude equation in its reference image and recommends COMPLEX for numeric component inputs.

Magnitude is a nonnegative distance from the origin. It is not the signed real coefficient, not the imaginary coefficient and not the sum of their absolute values. Reversing either component’s sign leaves this distance unchanged.

The equation gives a mathematical verification model. It does not establish that a direct helper expression and Excel’s internal algorithm have identical overflow or rounding behavior at extreme values.

Enter only the first column as text in A2:A5. In B2 use =IMABS(A2) and fill down.

For the third row, 5 squared plus −12 squared is 25+144=169, whose square root is 13. For the fourth, 64+225=289 and the square root is 17.

The first two records have different real coefficients but the same distance from the origin. A magnitude-only report loses directional information, so keep the original values when direction matters.

For A2:A5, enter =IMREAL(A2) in C2 and =IMAGINARY(A2) in D2, filling down. In E2 use:

=SQRT(C2^2+D2^2)

Fill through E5. Expected results are again 5, 5, 13 and 17. The component pairs are (3,4), (−3,4), (5,−12) and (−8,−15).

IMREAL and IMAGINARY extract numeric coefficients; SQRT operates on their nonnegative sum of squares. This is an independent small-value check, not a promise of identical native numeric behavior for every possible input scale.

Let P=4+3i and Q=1−i. Their difference is 3+4i, so their distance is five:

=IMABS(IMSUB("4+3i","1-i"))

Reversing the subtraction gives −3−4i, whose magnitude is also five. IMSUB preserves the directional difference, while IMABS removes the direction and keeps its length.

This is a coordinate-plane distance example. It does not assign units automatically; if the real and imaginary coefficients represent quantities with units, the model must define how those coordinates are comparable.

For the first record 3+4i, divide its real and imaginary coefficients by its magnitude. Numeric helpers =IMREAL(A2)/B2 and =IMAGINARY(A2)/B2 give 0.6 and 0.8.

Construct the normalized value with =COMPLEX(IMREAL(A2)/B2,IMAGINARY(A2)/B2), giving expected components 0.6 and 0.8. Their squares sum to one, so the normalized magnitude is one mathematically.

Normalization requires a nonzero magnitude. A zero complex value has no direction to retain. This guide does not assign a native IMABS parsing or division-error result to every zero representation; validate that prerequisite before using a division formula.

Take z1=3+4i and z2=3−4i. Each magnitude is five, so adding their magnitudes gives ten. Their complex sum is six with zero imaginary coefficient, whose magnitude is six.

Thus =IMABS(IMSUM("3+4i","3-4i")) has expected result six, while =IMABS("3+4i")+IMABS("3-4i") gives ten. IMSUM combines the components before magnitude is calculated.

For a nondegenerate comparison, 3+4i plus 6+8i gives 9+12i, magnitude 15, equal to the individual magnitudes 5+10. Equality in that aligned example does not establish the same rule for differently directed values.

The product of 3+4i and 1−i is 7+i. Its magnitude is the square root of 50, approximately 7.071067812. The separate magnitudes are five and the square root of two; their product gives the same mathematical value.

This independent identity is useful for checking IMPRODUCT results. Compare rounded numeric values or a stated tolerance when reproducing irrational results, rather than treating displayed decimal strings as exact values.

The dedicated reference does not supply a complete invalid-input error matrix or range-coercion policy. The examples use explicit valid complex values and moderate components.

No extreme-value overflow, underflow or native error precedence has been certified. All magnitudes and component identities here were independently calculated from the documented equation, not executed in Excel.

• Microsoft IMABS 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.