PRODUCT
Multiplies all the numbers given as arguments.
Syntax
expression.PRODUCT(args);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| args | Required | number | ApiRange | number[] | Up to 255 numeric values that will be multiplied. The first argument is required, subsequent arguments are optional. Arguments can be numbers, ranges, or arrays of numbers. |
Returns
number
Example
Multiply all the numbers given as arguments in a spreadsheet.
// How to return the result after multiplication in a spreadsheet.
// Use a function to multiply a list of numbers in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
worksheet.GetRange("A1").SetValue(func.PRODUCT(65, 34, 165, 6, 9, 54));