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();