Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ImAbs Method
Collapse the table of content
Expand the table of content

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: awfimabs_ZA06051152where: z = x + yi

Show:
© 2015 Microsoft