[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
IMARGUMENT ( complex-number )
Description: Computes the argument θ, an angle expressed in radians, such that for a complex number complex-number having the form x+yi:
Mathematical Formula:
where:
and z = x + yi
Arguments:
Name |
Type |
Description |
complex-number |
The complex number in x + yi or x + yj text format. |
Return Type and Value: number – The angle θ, expressed in radians.
However, if complex-number is ill-formed, #NUM! is returned.
[Example:
IMARGUMENT("13+4i") results in 0.298498932
IMARGUMENT("-2.5-5j") results in -2.034443936
end example]