AVERAGE
function AVERAGE(args: number | string | number[] = null): numberDescription
Returns the average (arithmetic mean) of the specified arguments.
Parameters
- args
number | string | number[]default: null Up to 255 numeric values for which the average value will be returned. The first argument is required, subsequent arguments are optional. Arguments can be numbers or names, arrays or references that contain numbers.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.AVERAGE(123, 197, 46, 345, 67, 456);
oWorksheet.GetRange("B2").SetValue(ans);