diff options
| author | xuri <xuri.me@gmail.com> | 2021-04-01 21:52:43 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-04-01 21:52:43 +0800 |
| commit | a002a2417e9cc9d8dc3d405d2d96f7dd24710082 (patch) | |
| tree | 4f5d9f7b9ee8a6b4f52ccdfccd0b5900b52aeea9 /calc_test.go | |
| parent | 9d4bf88b4700eeb5c50d4cc6efb0a2d73e5e8b7f (diff) | |
#65 fn: VAR.P and VARP and fix Yoda conditions issue
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index bce0c0f..c4f1924 100644 --- a/calc_test.go +++ b/calc_test.go @@ -705,6 +705,10 @@ func TestCalcCellValue(t *testing.T) { "=SMALL(A1:B5,2)": "1", "=SMALL(A1,1)": "1", "=SMALL(A1:F2,1)": "1", + // VARP + "=VARP(A1:A5)": "1.25", + // VAR.P + "=VAR.P(A1:A5)": "1.25", // Information Functions // ISBLANK "=ISBLANK(A1)": "FALSE", @@ -1528,6 +1532,12 @@ func TestCalcCellValue(t *testing.T) { "=SMALL(A1:A5,0)": "k should be > 0", "=SMALL(A1:A5,6)": "k should be <= length of array", "=SMALL(A1:A5,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + // VARP + "=VARP()": "VARP requires at least 1 argument", + "=VARP(\"\")": "#DIV/0!", + // VAR.P + "=VAR.P()": "VAR.P requires at least 1 argument", + "=VAR.P(\"\")": "#DIV/0!", // Information Functions // ISBLANK "=ISBLANK(A1,A2)": "ISBLANK requires 1 argument", |