From 620f873186e9f69a05d88f79cfb899b42e584331 Mon Sep 17 00:00:00 2001 From: xuri Date: Mon, 18 Oct 2021 00:18:56 +0800 Subject: ref #65: new formula function AMORLINC --- calc_test.go | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'calc_test.go') 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", -- cgit v1.2.1