Practice free

IMARGUMENT function

IMARGUMENT returns the angle (theta) of a complex number, in radians. To convert the result to degrees, multiply it by 180 divided by pi. A complex number of zero gives a #DIV/0! error.

Example

Read it as a sentence: find the angle, in radians, of the complex number 3+4i, which gives 0.927295218.

Practice this in the app

Syntax

IMARGUMENT(inumber)

inumber (required)
A complex number as text, like "3+4i".

Returns: The angle in radians.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=IMARGUMENT("3+4i") 0.927295218 "3+4i"
=IMARGUMENT("3+4j") 0.927295218 Suffix j
=IMARGUMENT(5) 0 Pure real number 5
=IMARGUMENT("5") 0 Pure real text "5"
=IMARGUMENT("i") 1.570796327 Pure imaginary "i"
=IMARGUMENT("-2i") -1.570796327 "-2i"
=IMARGUMENT(0) #DIV/0! Zero
=IMARGUMENT("3+4I") #NUM! Uppercase I

Watch out for

  • Result is in radians; multiply by 180/PI() for degrees.
  • Zero gives #DIV/0!.

Where it works

Excel
IMARGUMENT is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .