WorksheetFunction.Complex Method
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
 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 is nonnumeric, Complex generates an error.If is nonnumeric, Complex generates an error.If is neither "i" nor "j", Complex generates an error.
See also:
Arg1 Arg2 Arg3