diff options
| author | xuri <xuri.me@gmail.com> | 2021-03-25 00:05:02 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-03-25 00:05:02 +0800 |
| commit | e1abdb0e5a0ecae47dd0116c9165f4ad6e492856 (patch) | |
| tree | a0b92dc57ee720d2edde47db6e877ee5f64a4901 /calc_test.go | |
| parent | ab2c1c8fe1ef787c1f692bcf26c7bbe0cca2c5b3 (diff) | |
This closes #809, and add new fn: HARMEAN
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index f8397e7..65f7ce1 100644 --- a/calc_test.go +++ b/calc_test.go @@ -605,6 +605,9 @@ func TestCalcCellValue(t *testing.T) { // GAMMALN "=GAMMALN(4.5)": "2.453736570842443", "=GAMMALN(INT(1))": "0", + // HARMEAN + "=HARMEAN(2.5,3,0.5,1,3)": "1.229508196721312", + "=HARMEAN(\"2.5\",3,0.5,1,INT(3),\"\")": "1.229508196721312", // KURT "=KURT(F1:F9)": "-1.033503502551368", "=KURT(F1,F2:F9)": "-1.033503502551368", @@ -1393,6 +1396,10 @@ func TestCalcCellValue(t *testing.T) { "=GAMMALN(F1)": "GAMMALN requires 1 numeric argument", "=GAMMALN(0)": "#N/A", "=GAMMALN(INT(0))": "#N/A", + // HARMEAN + "=HARMEAN()": "HARMEAN requires at least 1 argument", + "=HARMEAN(-1)": "#N/A", + "=HARMEAN(0)": "#N/A", // KURT "=KURT()": "KURT requires at least 1 argument", "=KURT(F1,INT(1))": "#DIV/0!", |