diff options
| author | xuri <xuri.me@gmail.com> | 2022-03-15 00:05:02 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-03-15 00:05:02 +0800 |
| commit | 4220bf4327a35a07ac6b47b652a120ed978a3a2a (patch) | |
| tree | 5b9278b0b122e17d8cd95676f0dba457af86802e /calc_test.go | |
| parent | e1d660dda7c02475a8529a252e6c1fd171065429 (diff) | |
ref #65, new formula functions: LOGNORM.INV and LOGINV
* Update docs for the function `SetCellHyperLink`
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6407685..8f1c1e5 100644 --- a/calc_test.go +++ b/calc_test.go @@ -890,6 +890,10 @@ func TestCalcCellValue(t *testing.T) { "=F.INV.RT(0.5,4,8)": "0.914645355977072", "=F.INV.RT(0.1,79,86)": "1.32646097270444", "=F.INV.RT(1,40,5)": "0", + // LOGINV + "=LOGINV(0.3,2,0.2)": "6.6533460753367", + // LOGINV + "=LOGNORM.INV(0.3,2,0.2)": "6.6533460753367", // NORM.DIST "=NORM.DIST(0.8,1,0.3,TRUE)": "0.252492537546923", "=NORM.DIST(50,40,20,FALSE)": "0.017603266338215", @@ -2487,6 +2491,22 @@ func TestCalcCellValue(t *testing.T) { "=F.INV.RT(0,1,2)": "#NUM!", "=F.INV.RT(0.2,0.5,2)": "#NUM!", "=F.INV.RT(0.2,1,0.5)": "#NUM!", + // LOGINV + "=LOGINV()": "LOGINV requires 3 arguments", + "=LOGINV(\"\",2,0.2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGINV(0.3,\"\",0.2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGINV(0.3,2,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGINV(0,2,0.2)": "#NUM!", + "=LOGINV(1,2,0.2)": "#NUM!", + "=LOGINV(0.3,2,0)": "#NUM!", + // LOGNORM.INV + "=LOGNORM.INV()": "LOGNORM.INV requires 3 arguments", + "=LOGNORM.INV(\"\",2,0.2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGNORM.INV(0.3,\"\",0.2)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGNORM.INV(0.3,2,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=LOGNORM.INV(0,2,0.2)": "#NUM!", + "=LOGNORM.INV(1,2,0.2)": "#NUM!", + "=LOGNORM.INV(0.3,2,0)": "#NUM!", // NORM.DIST "=NORM.DIST()": "NORM.DIST requires 4 arguments", // NORMDIST |