Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction.ImAbs Method

Office 2007
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

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantInumber - 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:

    Equation

    where:

    z = x + yi




Community Additions

Show:
© 2016 Microsoft