WorksheetFunction.ImProduct Method (Excel)
Returns the product of 2 to 29 complex numbers in x + yi or x + yj text format.
Syntax
expression .ImProduct(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 - Arg30 |
Required |
Variant |
Inumber1, inumber2,… - 1 to 29 complex numbers to multiply. |
Return Value
String
Remarks
Use COMPLEX to convert real and imaginary coefficients into a complex number.
The product of two complex numbers is:
.gif "Ff821835.awfimprd_ZA06051163(en-us,office.14).gif")