This documentation is archived and is not being maintained.

WorksheetFunction.ImAbs Method (Excel)

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

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

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

  • The absolute value of a complex number is: Ff821850.awfimabs_ZA06051152(en-us,office.14).gifwhere: z = x + yi

Show: