WorksheetFunction.Complex Method
| Excel Developer Reference |
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Syntax
expression.Complex(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | The real coefficient of the complex number. |
| Arg2 | Required | Variant | The imaginary coefficient of the complex number. |
| Arg3 | Optional | Variant | The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i". |
Return Value
String
Remarks
.gif "Bb239233.vs_note(en-us,office.12).gif") Note |
|---|
| All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase generates an error. All functions that accept two or more complex numbers require that all suffixes match. |
- If Arg1
- If Arg2
- If Arg3
See Also