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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for