WorksheetFunction.ImAbs Method

Excel Developer Reference

Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.

Syntax

expression.ImAbs(Arg1)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name	Required/Optional	Data Type	Description
Arg1	Required	Variant	Inumber - a complex number for which you want the absolute value.

Return Value
String

Remarks

• Use COMPLEX to convert real and imaginary coefficients into a complex number.

• The absolute value of a complex number is:

  

  where:

  z = x + yi

See Also

• WorksheetFunction Object
• WorksheetFunction Object Members