diff options
| author | xuri <xuri.me@gmail.com> | 2021-10-18 00:18:56 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-10-18 00:18:56 +0800 |
| commit | 620f873186e9f69a05d88f79cfb899b42e584331 (patch) | |
| tree | 22fac795ba47c175c647391adc400d0f66966fa3 /calc_test.go | |
| parent | c89b64c53c8314b71374f85fabf29175646e10b2 (diff) | |
ref #65: new formula function AMORLINC
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6d16ce9..abf6afa 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1242,6 +1242,12 @@ func TestCalcCellValue(t *testing.T) { "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",20,1,25%,4)": "41", "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",109,1,25%,4)": "54", "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",110,2,25%,4)": "0", + // AMORLINC + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,20%,4)": "30", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,0%,4)": "0", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,20,15%,4)": "0", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,6,15%,4)": "0.6875", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,0,15%,4)": "16.8125", // CUMIPMT "=CUMIPMT(0.05/12,60,50000,1,12,0)": "-2294.97753732664", "=CUMIPMT(0.05/12,60,50000,13,24,0)": "-1833.1000665738893", @@ -2327,6 +2333,21 @@ func TestCalcCellValue(t *testing.T) { "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",20,1,20%,\"\")": "#NUM!", "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",20,1,50%)": "AMORDEGRC requires rate to be < 0.5", "=AMORDEGRC(150,\"01/01/2015\",\"09/30/2015\",20,1,20%,5)": "invalid basis", + // AMORLINC + "=AMORLINC()": "AMORLINC requires 6 or 7 arguments", + "=AMORLINC(\"\",\"01/01/2015\",\"09/30/2015\",20,1,20%)": "AMORLINC requires cost to be number argument", + "=AMORLINC(-1,\"01/01/2015\",\"09/30/2015\",20,1,20%)": "AMORLINC requires cost >= 0", + "=AMORLINC(150,\"\",\"09/30/2015\",20,1,20%)": "#VALUE!", + "=AMORLINC(150,\"01/01/2015\",\"\",20,1,20%)": "#VALUE!", + "=AMORLINC(150,\"09/30/2015\",\"01/01/2015\",20,1,20%)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",\"\",1,20%)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",-1,1,20%)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,\"\",20%)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,-1,20%)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,\"\")": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,-1)": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,20%,\"\")": "#NUM!", + "=AMORLINC(150,\"01/01/2015\",\"09/30/2015\",20,1,20%,5)": "invalid basis", // CUMIPMT "=CUMIPMT()": "CUMIPMT requires 6 arguments", "=CUMIPMT(0,0,0,0,0,2)": "#N/A", |