GEOMEAN
function GEOMEAN(args: ApiRange | number[] = null): number
Description
Returns the geometric mean of an array or range of positive numeric data.
Parameters
Up to 255 numeric values for which the geometric mean will be calculated.
Returns
number
Try It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.GEOMEAN(28, 16, 878, 800, 1650, 2000);
oWorksheet.GetRange("B2").SetValue(ans);