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.
A
B
C
D
1
0.927295218
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .