WorksheetFunction.ImAbs(Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 System::String ^ ImAbs(System::Object ^ Arg1);

public string ImAbs (object Arg1);

Public Function ImAbs (Arg1 As Object) As String

Parameters

Arg1: Object

Inumber - a complex number for which you want the absolute value.

Returns

String

Remarks

Use Complex(Object, Object, Object) to convert real and imaginary coefficients into a complex number.

The absolute value of a complex number is:

Figure 1: Equation for absolute value of a complex number

where:

z = x + yi

Applies to