Returns the geometric mean of an array or range of positive numeric data.
Name | Type | Description |
args | ApiRange | Array.<number> | Up to 255 numeric values for which the geometric mean will be calculated. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); var ans = oFunction.GEOMEAN(28, 16, 878, 800, 1650, 2000); oWorksheet.GetRange("B2").SetValue(ans); builder.SaveFile("xlsx", "GEOMEAN.xlsx"); builder.CloseFile();