Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals.
| Name | Type | Description |
| args | ApiRange | Array.<number> | Up to 255 numeric values for which the harmonic mean will be calculated. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.HARMEAN(28, 16, 878, 800, 1650, 2000);
oWorksheet.GetRange("B2").SetValue(ans);
builder.SaveFile("xlsx", "HARMEAN.xlsx");
builder.CloseFile();