AGGREGATE
function AGGREGATE(): number | string | booleanDescription
Returns an aggregate in a list or database.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.AGGREGATE(9, 4, 10, 30, 50, 5));