WorksheetFunction.ImSum Method

Excel Developer Reference

Returns the sum of two or more complex numbers in x + yi or x + yj text format.

Syntax

expression.ImSum(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 add.

Return Value
String

Remarks

  • Use COMPLEX to convert real and imaginary coefficients into a complex number.

  • The sum of two complex numbers is:

    Equation

See Also