test suite

math

65 tests · 20 with documented divergences

Test	Subject	Formula	Category	DVs
`24612f`	ABS	`=ABS(3)`	value
`ab1ab4`	ABS	`=ABS(-3.4)`	value
`f19130`	ABS	`=ABS(0)`	value
`9bed14`	CEILING	`=CEILING(2.5, 1)`	value
`9a070b`	CEILING	`=CEILING(-2.5, -2)`	value
`41b47f`	CEILING	`=CEILING(-2.5, 2)`	value
`1f8864`	CEILING	`=CEILING(0.234, 0.01)`	value
`57203f`	CEILING	`=CEILING(2, -2)`	value	1
`a46ba6`	CEILING.MATH	`=CEILING.MATH(5.2)`	value	1
`2c01fa`	CEILING.MATH	`=CEILING.MATH(5.2, 2)`	value	1
`944b4c`	FLOOR	`=FLOOR(3.7, 2)`	value
`256714`	FLOOR	`=FLOOR(-2.5, -2)`	value
`dcfa3c`	FLOOR	`=FLOOR(1.58, 0.1)`	value
`0c5ada`	FLOOR	`=FLOOR(0.234, 0.01)`	value
`60444b`	FLOOR	`=FLOOR(2, 0)`	value	1
`0a8fdc`	FLOOR.MATH	`=FLOOR.MATH(5.2)`	value	1
`eab644`	FLOOR.MATH	`=FLOOR.MATH(5.2, 2)`	value	1
`5c168a`	INT	`=INT(8.9)`	value
`529340`	INT	`=INT(-8.9)`	value	1
`a850e3`	MOD	`=MOD(5, 2)`	value
`5e7181`	MOD	`=MOD(6, 3)`	value
`488174`	MOD	`=MOD(-5, 2)`	value	1
`610d9e`	MOD	`=MOD(5, 0)`	value
`f91eba`	POWER	`=POWER(10, 2)`	value
`efd016`	POWER	`=POWER(2.5, 2)`	value
`e7e4c2`	POWER	`=POWER(2, -3)`	value
`b81fb1`	ROUND	`=ROUND(0.6, 0)`	value
`c9ca33`	ROUND	`=ROUND(1.3, 0)`	value
`33e984`	ROUND	`=ROUND(1.25, 1)`	value
`518eef`	ROUND	`=ROUND(1234, -2)`	value
`d2f0eb`	ROUND	`=ROUND(1.05*(0.0284+0.0046)-0.0284, 4)`	value	1
`105372`	ROUNDUP	`=ROUNDUP(1.24, 1)`	value
`fc63cd`	ROUNDDOWN	`=ROUNDDOWN(1.26, 1)`	value
`a926df`	SQRT	`=SQRT(4)`	value
`2ab9b5`	SQRT	`=SQRT(2)`	value	3
`0d88cc`	SQRT	`=SQRT(-4)`	value	1
`28eed2`	SUM	`=SUM(1, 2, 3)`	value
`5a649c`	SUM	`=SUM({1, 2, 3})`	value
`4978aa`	SUM	`=SUM({1; 2; 3})`	value
`ce8dba`	SUM	`=SUM({1, 2; 3, 4; 5, 6})`	value
`ff9c49`	SUM	`=SUM(A1:A3)`	value
`c87a9e`	SUM	`=SUM()`	value
`0d371c`	SUMPRODUCT	`=SUMPRODUCT(A1:A3, B1:B3)`	value	2
`663970`	EXP	`=EXP(0)`	value
`9f2425`	EXP	`=EXP(1)`	value	3
`759e4f`	SIGN	`=SIGN(10)`	value
`bd7410`	SIGN	`=SIGN(0)`	value
`766f91`	SIGN	`=SIGN(-10)`	value
`85eb30`	MROUND	`=MROUND(10, 3)`	value	1
`980fea`	TRUNC	`=TRUNC(10)`	value
`127d72`	TRUNC	`=TRUNC(10.22, 1)`	value
`12439b`	SUMSQ	`=SUMSQ(2)`	value	1
`c45ea8`	SUMSQ	`=SUMSQ(1, 2)`	value	1
`a3139c`	LN	`=LN(2.718281828459045)`	value	1
`6c12c4`	LOG	`=LOG(10)`	value
`bb8d9a`	LOG	`=LOG(8, 2)`	value
`47636e`	LOG10	`=LOG10(100000)`	value
`e3628f`	FACT	`=FACT(5)`	value
`4b9d5c`	FACT	`=FACT(0)`	value
`de34d7`	FACT	`=FACT(-1)`	value	1
`180adc`	QUOTIENT	`=QUOTIENT(5, 2)`	value	1
`e62480`	EVEN	`=EVEN(1.5)`	value
`8902ae`	EVEN	`=EVEN(3)`	value
`734a28`	EVEN	`=EVEN(-1)`	value
`995e42`	PI	`=PI()`	value	3