diff options
| author | xuri <xuri.me@gmail.com> | 2022-03-12 00:45:27 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-03-12 00:45:27 +0800 |
| commit | e1d660dda7c02475a8529a252e6c1fd171065429 (patch) | |
| tree | 1e0f9eceef95df5189ea50d8b6f21055f0771551 /calc_test.go | |
| parent | 361611c23ae56cac091d5c7d73f5ea305b5bd3fc (diff) | |
ref #65, new formula functions: GAMMA.INV and GAMMAINV and format code
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 0c9fb2e..6407685 100644 --- a/calc_test.go +++ b/calc_test.go @@ -841,6 +841,12 @@ func TestCalcCellValue(t *testing.T) { // GAMMADIST "=GAMMADIST(6,3,2,FALSE)": "0.112020903827694", "=GAMMADIST(6,3,2,TRUE)": "0.576809918873156", + // GAMMA.INV + "=GAMMA.INV(0.5,3,2)": "5.348120627447122", + "=GAMMA.INV(0.5,0.5,1)": "0.227468211559786", + // GAMMAINV + "=GAMMAINV(0.5,3,2)": "5.348120627447122", + "=GAMMAINV(0.5,0.5,1)": "0.227468211559786", // GAMMALN "=GAMMALN(4.5)": "2.45373657084244", "=GAMMALN(INT(1))": "0", @@ -2406,6 +2412,24 @@ func TestCalcCellValue(t *testing.T) { "=GAMMADIST(-1,3,2,FALSE)": "#NUM!", "=GAMMADIST(6,0,2,FALSE)": "#NUM!", "=GAMMADIST(6,3,0,FALSE)": "#NUM!", + // GAMMA.INV + "=GAMMA.INV()": "GAMMA.INV requires 3 arguments", + "=GAMMA.INV(\"\",3,2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMA.INV(0.5,\"\",2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMA.INV(0.5,3,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMA.INV(-1,3,2)": "#NUM!", + "=GAMMA.INV(2,3,2)": "#NUM!", + "=GAMMA.INV(0.5,0,2)": "#NUM!", + "=GAMMA.INV(0.5,3,0)": "#NUM!", + // GAMMAINV + "=GAMMAINV()": "GAMMAINV requires 3 arguments", + "=GAMMAINV(\"\",3,2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMAINV(0.5,\"\",2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMAINV(0.5,3,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=GAMMAINV(-1,3,2)": "#NUM!", + "=GAMMAINV(2,3,2)": "#NUM!", + "=GAMMAINV(0.5,0,2)": "#NUM!", + "=GAMMAINV(0.5,3,0)": "#NUM!", // GAMMALN "=GAMMALN()": "GAMMALN requires 1 numeric argument", "=GAMMALN(F1)": "GAMMALN requires 1 numeric argument", |