WorksheetFunction.Complex method (Excel)
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
If Arg1 is nonnumeric, Complex generates an error.
If Arg2 is nonnumeric, Complex generates an error.
If Arg3 is neither "i" nor "j", Complex generates an error.
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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.