diff options
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 4436b60..b8efd61 100644 --- a/calc_test.go +++ b/calc_test.go @@ -4632,6 +4632,7 @@ func TestCalcDatabase(t *testing.T) { "=DCOUNTA(A4:E10,\"Profit\",A1:F2)": "2", "=DCOUNTA(A4:E10,\"Tree\",A1:F2)": "2", "=DCOUNTA(A4:E10,\"Age\",A2:F3)": "0", + "=DGET(A4:E6,\"Profit\",A1:F3)": "96", "=DMAX(A4:E10,\"Tree\",A1:F3)": "0", "=DMAX(A4:E10,\"Profit\",A1:F3)": "96", "=DMIN(A4:E10,\"Tree\",A1:F3)": "0", @@ -4665,6 +4666,9 @@ func TestCalcDatabase(t *testing.T) { "=DCOUNTA(A4:E10,NA(),A1:F2)": "#VALUE!", "=DCOUNTA(A4:E4,,A1:F2)": "#VALUE!", "=DCOUNTA(A4:E10,\"x\",A2:F3)": "#VALUE!", + "=DGET()": "DGET requires 3 arguments", + "=DGET(A4:E5,\"Profit\",A1:F3)": "#VALUE!", + "=DGET(A4:E10,\"Profit\",A1:F3)": "#NUM!", "=DMAX()": "DMAX requires 3 arguments", "=DMAX(A4:E10,\"x\",A1:F3)": "#VALUE!", "=DMIN()": "DMIN requires 3 arguments", |