WorksheetFunction.ImAbs Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function ImAbs ( _
    Arg1 As Object _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As String

returnValue = instance.ImAbs(Arg1)

string ImAbs(
    Object Arg1
)

Parameters

• Arg1
  Type: System.Object

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

Return Value

Type: System.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

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace