From 8f82d8b02909ca96a9c7f7c3431d1ae990c90191 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Mon, 8 Nov 2021 00:19:28 +0800
Subject: ref #65: new formula functions COUPNCD and COUPNUM

---
 calc_test.go | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

(limited to 'calc_test.go')

diff --git a/calc_test.go b/calc_test.go
index 3e36ef8..26c1ca1 100644
--- a/calc_test.go
+++ b/calc_test.go
@@ -1393,6 +1393,13 @@ func TestCalcCellValue(t *testing.T) {
 		"=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",
+		// COUPNCD
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",4)":   "40568",
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",4,0)": "40568",
+		"=COUPNCD(\"10/25/2011\",\"01/01/2012\",4)":   "40909",
+		// COUPNUM
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",4)":   "8",
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",4,0)": "8",
 		// COUPPCD
 		"=COUPPCD(\"01/01/2011\",\"10/25/2012\",4)":   "40476",
 		"=COUPPCD(\"01/01/2011\",\"10/25/2012\",4,0)": "40476",
@@ -2689,6 +2696,24 @@ func TestCalcCellValue(t *testing.T) {
 		"=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",
+		// COUPNCD
+		"=COUPNCD()": "COUPNCD requires 3 or 4 arguments",
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",4,0,0)":  "COUPNCD requires 3 or 4 arguments",
+		"=COUPNCD(\"\",\"10/25/2012\",4)":                "#VALUE!",
+		"=COUPNCD(\"01/01/2011\",\"\",4)":                "#VALUE!",
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",\"\")":   "#VALUE!",
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",4,\"\")": "#NUM!",
+		"=COUPNCD(\"01/01/2011\",\"10/25/2012\",3)":      "#NUM!",
+		"=COUPNCD(\"10/25/2012\",\"01/01/2011\",4)":      "COUPNCD requires maturity > settlement",
+		// COUPNUM
+		"=COUPNUM()": "COUPNUM requires 3 or 4 arguments",
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",4,0,0)":  "COUPNUM requires 3 or 4 arguments",
+		"=COUPNUM(\"\",\"10/25/2012\",4)":                "#VALUE!",
+		"=COUPNUM(\"01/01/2011\",\"\",4)":                "#VALUE!",
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",\"\")":   "#VALUE!",
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",4,\"\")": "#NUM!",
+		"=COUPNUM(\"01/01/2011\",\"10/25/2012\",3)":      "#NUM!",
+		"=COUPNUM(\"10/25/2012\",\"01/01/2011\",4)":      "COUPNUM requires maturity > settlement",
 		// COUPPCD
 		"=COUPPCD()": "COUPPCD requires 3 or 4 arguments",
 		"=COUPPCD(\"01/01/2011\",\"10/25/2012\",4,0,0)":  "COUPPCD requires 3 or 4 arguments",
-- 
cgit v1.2.1