[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

IMARGUMENT

Syntax:

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

text

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]