test suite

operator

115 tests · 105 with documented divergences

Test	Subject	Formula	Category	DVs
`90a100`	ADD	`=ADD(2, 3)`	value	1
`0aa158`	ADD	`=ADD(-4, 1)`	value	1
`1d164a`	ADD	`=ADD(0, 0)`	value	1
`21e9ba`	ADD	`=ADD(0.1, 0.2)`	value	1
`eb257a`	ADD	`=ADD(TRUE, 1)`	value	2
`a6e889`	ADD	`=ADD("2", 3)`	value	2
`6dc9d4`	ADD	`=ADD("abc", 1)`	value
`93bef3`	ADD	`=ADD(7, 11)=7+11`	value	1
`db589b`	MINUS	`=MINUS(10, 3)`	value	1
`4c1ba8`	MINUS	`=MINUS(3, 10)`	value	1
`d8f194`	MINUS	`=MINUS(5, 5)`	value	1
`86c06a`	MINUS	`=MINUS(TRUE, FALSE)`	value	1
`418487`	MINUS	`=MINUS("10", "4")`	value	1
`ff3e43`	MINUS	`=MINUS(9, 4)=9-4`	value	1
`ad2db1`	MULTIPLY	`=MULTIPLY(6, 7)`	value	1
`0e1837`	MULTIPLY	`=MULTIPLY(123, 0)`	value	1
`f7cf20`	MULTIPLY	`=MULTIPLY(-3, 4)`	value	1
`5bdf1e`	MULTIPLY	`=MULTIPLY(TRUE, 5)`	value	1
`5c7b87`	MULTIPLY	`=MULTIPLY("3", 4)`	value	1
`29c892`	MULTIPLY	`=MULTIPLY(6, 7)=6*7`	value	1
`c6c74f`	DIVIDE	`=DIVIDE(20, 4)`	value	1
`138f72`	DIVIDE	`=DIVIDE(1, 0)`	value	1
`fa7a8a`	DIVIDE	`=DIVIDE(1, 3)`	value	1
`6dcb32`	DIVIDE	`=DIVIDE(-12, 4)`	value	1
`c16201`	DIVIDE	`=DIVIDE("10", "2")`	value	1
`e1f847`	DIVIDE	`=DIVIDE(100, 4)=100/4`	value	1
`1b58dc`	POW	`=POW(2, 10)`	value	1
`a74e1e`	POW	`=POW(5, 0)`	value	1
`cebbd2`	POW	`=POW(2, -3)`	value	1
`b27e39`	POW	`=POW(2, 0.5)`	value	1
`a3609e`	POW	`=POW(-1, 0.5)`	value	2
`62cbe9`	POW	`=POW(0, 0)`	value	1
`71c6a6`	POW	`=POW(3, 4)=3^4`	value	1
`63dc07`	UMINUS	`=UMINUS(5)`	value	1
`0f8717`	UMINUS	`=UMINUS(-3)`	value	1
`c361d2`	UMINUS	`=UMINUS(0)`	value	1
`83cbbf`	UMINUS	`=UMINUS(TRUE)`	value	1
`37ba76`	UMINUS	`=UMINUS("7")`	value	1
`69644f`	UMINUS	`=UMINUS(42)=-42`	value	1
`934e46`	UPLUS	`=UPLUS(5)`	value	1
`f94768`	UPLUS	`=UPLUS(-3)`	value	1
`cd4fbd`	UPLUS	`=UPLUS(0)`	value	1
`a319c4`	UPLUS	`=UPLUS(TRUE)`	value	1
`a65d22`	UPLUS	`=UPLUS("hello")`	value	1
`240955`	UPLUS	`=UPLUS("3.14")`	value	1
`560727`	UNARY_PERCENT	`=UNARY_PERCENT(50)`	value	1
`6d265c`	UNARY_PERCENT	`=UNARY_PERCENT(1)`	value	1
`5c442d`	UNARY_PERCENT	`=UNARY_PERCENT(0)`	value	1
`e6adbb`	UNARY_PERCENT	`=UNARY_PERCENT(-25)`	value	1
`207fb5`	UNARY_PERCENT	`=UNARY_PERCENT(100)`	value	1
`cb7e15`	UNARY_PERCENT	`=UNARY_PERCENT("50")`	value	1
`1d402b`	UNARY_PERCENT	`=UNARY_PERCENT(75)=75%`	value	1
`c3302a`	CONCAT	`=CONCAT("hello", " ", "world")`	value	2
`f319fc`	CONCAT	`=CONCAT("foo", "bar")`	value	1
`0a2660`	CONCAT	`=CONCAT(1, 2)`	value	1
`5ef694`	CONCAT	`=CONCAT("x=", 42)`	value	1
`5afaaf`	CONCAT	`=CONCAT(TRUE, FALSE)`	value	1
`52041c`	CONCAT	`=CONCAT(1.5, 2.25)`	value	1
`172694`	CONCAT	`=CONCAT("", "abc")`	value	1
`296636`	CONCAT	`=CONCAT("a", "b")="a"&"b"`	value	1
`04e93a`	EQ	`=EQ(1, 1)`	value	1
`29201c`	EQ	`=EQ(1, 2)`	value	1
`c8790e`	EQ	`=EQ("abc", "abc")`	value	1
`a5ed35`	EQ	`=EQ("ABC", "abc")`	value	1
`83fbd4`	EQ	`=EQ("1", 1)`	value	1
`a9edcc`	EQ	`=EQ(TRUE, 1)`	value	1
`4896ab`	EQ	`=EQ("", 0)`	value	1
`b53434`	EQ	`=EQ(5, 5)=(5=5)`	value	1
`a4c97c`	NE	`=NE(1, 2)`	value	1
`64a81e`	NE	`=NE(1, 1)`	value	1
`c702b7`	NE	`=NE("a", "b")`	value	1
`9fa3bc`	NE	`=NE("1", 1)`	value	1
`db99ba`	NE	`=NE("ABC", "abc")`	value	1
`ce462d`	NE	`=NE(1, 2)=(1<>2)`	value	1
`1eebe3`	GT	`=GT(5, 3)`	value	1
`6d9398`	GT	`=GT(5, 5)`	value	1
`f0d982`	GT	`=GT(2, 5)`	value	1
`bb1000`	GT	`=GT("b", "a")`	value	1
`ddef45`	GT	`=GT("10", 9)`	value	1
`057834`	GT	`=GT(TRUE, 0)`	value
`ef291b`	GT	`=GT(5, 3)=(5>3)`	value	1
`97c93d`	GTE	`=GTE(5, 3)`	value	1
`60ee3a`	GTE	`=GTE(5, 5)`	value	1
`007266`	GTE	`=GTE(2, 5)`	value	1
`d5deea`	GTE	`=GTE("5", 5)`	value	1
`56f9b8`	GTE	`=GTE(TRUE, 1)`	value
`e9e4b0`	GTE	`=GTE(5, 5)=(5>=5)`	value	1
`590a48`	LT	`=LT(2, 5)`	value	1
`a19d04`	LT	`=LT(5, 5)`	value	1
`271907`	LT	`=LT(5, 2)`	value	1
`ead751`	LT	`=LT("a", "b")`	value	1
`603b20`	LT	`=LT("9", 10)`	value	1
`89401d`	LT	`=LT(2, 5)=(2<5)`	value	1
`6c9de7`	LTE	`=LTE(2, 5)`	value	1
`d7a656`	LTE	`=LTE(5, 5)`	value	1
`cbea3c`	LTE	`=LTE(5, 2)`	value	1
`00930d`	LTE	`=LTE("5", 5)`	value	1
`1dce7d`	LTE	`=LTE(FALSE, 0)`	value
`175234`	LTE	`=LTE(2, 5)=(2<=5)`	value	1
`de197a`	ISBETWEEN	`=ISBETWEEN(5, 1, 10)`	value	1
`79334a`	ISBETWEEN	`=ISBETWEEN(0, 1, 10)`	value	1
`81f240`	ISBETWEEN	`=ISBETWEEN(11, 1, 10)`	value	1
`7f4682`	ISBETWEEN	`=ISBETWEEN(1, 1, 10)`	value	1
`f3d8eb`	ISBETWEEN	`=ISBETWEEN(10, 1, 10)`	value	1
`8d3b9a`	ISBETWEEN	`=ISBETWEEN(1, 1, 10, FALSE)`	value	1
`f586b5`	ISBETWEEN	`=ISBETWEEN(10, 1, 10, TRUE, FALSE)`	value	1
`610e14`	ISBETWEEN	`=ISBETWEEN(5, 1, 10, FALSE, FALSE)`	value	1
`421a78`	ISBETWEEN	`=ISBETWEEN("5", 1, 10)`	value	1
`d4e3c9`	ISBETWEEN	`=ISBETWEEN(-5, -10, -1)`	value	1
`b48f82`	UNIQUE	`=UNIQUE(A1:A5)`	value
`f9e231`	UNIQUE	`=UNIQUE(A1:A4)`	value
`cb3aa7`	UNIQUE	`=UNIQUE(A1:B4)`	value
`4aa963`	UNIQUE	`=UNIQUE(A1:A3)`	value
`c1cb0f`	UNIQUE	`=UNIQUE(A1:A3)`	value
`6382c4`	UNIQUE	`=UNIQUE(A1:A3)`	value