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