Wauvel

Excel like a finance pro.

← The library

Engineering function

IMARGUMENT

Returns the argument theta of a complex number, an angle in radians.

Rarely usedDifficulty 1500 · AdvancedUsage rank #491 of 520
Practice · 2 questions →

When to use it

The argument (angle) of a complex number in radians, between -pi and pi.

The shape of it

Syntax
=IMARGUMENT(inumber)

Worked examples

  • Classic

    =IMARGUMENT("3+4i") → 0.927295218

    About 53.1°.

  • 45 degrees

    =IMARGUMENT("1+i") → 0.785398163

    Pi over four.

  • Negative real

    =IMARGUMENT("-1") → 3.141592654

    Pi for a negative real.

Worth knowing

  • Phase angle of a phasor; DEGREES for a readable answer.
  • Same as ATAN2(re,im).
  • Pair with IMABS for polar form.

Where it goes wrong

  • #DIV/0! for "0".
  • #VALUE! for invalid text.

Related

CONVERTBIN2DECDEC2BINHEX2DECDEC2HEXDELTA

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.