COMPLEX
function COMPLEX(arg1: any = null, arg2: any = null, arg3: any = null): number | string | booleanDescription
Converts real and imaginary coefficients into a complex number.
Parameters
- arg1
anydefault: null Is the real coefficient of the complex number.
- arg2
anydefault: null Is the imaginary coefficient of the complex number.
- arg3
anydefault: null Is the suffix for the imaginary component of the complex number.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.COMPLEX(-2, 2.5, "i"));