test suite

info

93 tests · 30 with documented divergences

Test	Subject	Formula	Category	DVs
`209a4e`	ISNUMBER	`=ISNUMBER(42)`	value
`319253`	ISNUMBER	`=ISNUMBER(3.14)`	value
`13c205`	ISNUMBER	`=ISNUMBER("hello")`	value
`0480a6`	ISNUMBER	`=ISNUMBER("42")`	value	1
`1c6c0e`	ISNUMBER	`=ISNUMBER(TRUE)`	value	1
`de29e9`	ISNUMBER	`=ISNUMBER(A1)`	value
`5773c4`	ISNUMBER	`=ISNUMBER(A1)`	value
`1db6a8`	ISNUMBER	`=ISNUMBER(1/0)`	error-code
`2c2174`	ISTEXT	`=ISTEXT("hello")`	value
`5ea43b`	ISTEXT	`=ISTEXT("")`	value
`7ff3e4`	ISTEXT	`=ISTEXT(42)`	value
`b25aad`	ISTEXT	`=ISTEXT(TRUE)`	value
`bd92fe`	ISTEXT	`=ISTEXT(A1)`	value
`452a0c`	ISTEXT	`=ISTEXT(A1)`	value
`ff42a9`	ISTEXT	`=ISTEXT(1/0)`	error-code
`874944`	ISNONTEXT	`=ISNONTEXT(42)`	value
`911d5b`	ISNONTEXT	`=ISNONTEXT("hello")`	value
`f0a176`	ISNONTEXT	`=ISNONTEXT(TRUE)`	value
`51a03d`	ISNONTEXT	`=ISNONTEXT(A1)`	value
`0804e2`	ISNONTEXT	`=ISNONTEXT(1/0)`	error-code
`e658ae`	ISLOGICAL	`=ISLOGICAL(TRUE)`	value	1
`23f83b`	ISLOGICAL	`=ISLOGICAL(FALSE)`	value	1
`3aaa8e`	ISLOGICAL	`=ISLOGICAL(1)`	value
`d6eafd`	ISLOGICAL	`=ISLOGICAL("TRUE")`	value
`d0edff`	ISLOGICAL	`=ISLOGICAL(A1)`	value
`b893c3`	ISLOGICAL	`=ISLOGICAL(1/0)`	error-code
`08ab03`	ISBLANK	`=ISBLANK(A1)`	value
`f288a8`	ISBLANK	`=ISBLANK(A1)`	value
`ef5e32`	ISBLANK	`=ISBLANK(A1)`	value
`163697`	ISBLANK	`=ISBLANK(A1)`	value
`7370f6`	ISBLANK	`=ISBLANK(42)`	value
`4fb791`	ISBLANK	`=ISBLANK("")`	value
`f661fc`	ISERR	`=ISERR(1/0)`	value
`c3e522`	ISERR	`=ISERR(NA())`	value
`73e6ab`	ISERR	`=ISERR(42)`	value
`559f10`	ISERR	`=ISERR("hello")`	value
`59ded5`	ISERR	`=ISERR(A1)`	value
`afea3d`	ISERROR	`=ISERROR(1/0)`	value
`9767a3`	ISERROR	`=ISERROR(NA())`	value
`d6319a`	ISERROR	`=ISERROR("a"+1)`	value
`e737b0`	ISERROR	`=ISERROR(42)`	value
`a208eb`	ISERROR	`=ISERROR("hello")`	value
`dfc5ac`	ISERROR	`=ISERROR(A1)`	value
`e359fb`	ISNA	`=ISNA(NA())`	value
`d42020`	ISNA	`=ISNA(1/0)`	value
`67426a`	ISNA	`=ISNA(42)`	value
`4c73e3`	ISNA	`=ISNA("hello")`	value
`db4862`	ISNA	`=ISNA(MATCH(99, {1,2,3}, 0))`	value
`e30cb1`	ISFORMULA	`=ISFORMULA(A1)`	value	2
`08e9f8`	ISFORMULA	`=ISFORMULA(A1)`	value	2
`6074fe`	ISFORMULA	`=ISFORMULA(A1)`	value	2
`0b6ab6`	ISFORMULA	`=ISFORMULA(A1)`	value	2
`6d8f00`	ISREF	`=ISREF(A1)`	value
`33eee6`	ISREF	`=ISREF(A1:A3)`	value
`c97757`	ISREF	`=ISREF(42)`	value	1
`1121b3`	ISREF	`=ISREF("A1")`	value	1
`2046b2`	ISREF	`=ISREF(INDIRECT("A1"))`	value
`63f6b1`	ISDATE	`=ISDATE("2024-01-15")`	value
`f67c20`	ISDATE	`=ISDATE(42)`	value	2
`78c5b1`	ISDATE	`=ISDATE("hello")`	value	2
`373619`	ISDATE	`=ISDATE(DATE(2024,1,15))`	value	2
`c45267`	ISEMAIL	`=ISEMAIL("[email protected]")`	value	2
`5b80a8`	ISEMAIL	`=ISEMAIL("not-an-email")`	value	2
`436206`	ISEMAIL	`=ISEMAIL(42)`	value	2
`ae5ba5`	ISEMAIL	`=ISEMAIL(A1)`	value	2
`473584`	N	`=N(42)`	value
`43f3dd`	N	`=N("hello")`	value
`b17004`	N	`=N(TRUE)`	value	2
`6567ec`	N	`=N(FALSE)`	value	2
`26c526`	N	`=N(A1)`	value
`a4f4c3`	N	`=N(1/0)`	error-code
`ecdbee`	NA	`=NA()`	value
`d89bfe`	NA	`=NA()+1`	value
`8119b9`	TYPE	`=TYPE(42)`	value
`4cc6fa`	TYPE	`=TYPE("hello")`	value
`1fdac6`	TYPE	`=TYPE(TRUE)`	value
`ca4390`	TYPE	`=TYPE(1/0)`	error-code
`764a70`	TYPE	`=TYPE({1,2,3})`	value
`97ecdb`	TYPE	`=TYPE(A1)`	value
`8f96b3`	ERROR.TYPE	`=ERROR.TYPE(1/0)`	error-code	1
`eae8e2`	ERROR.TYPE	`=ERROR.TYPE(NA())`	error-code	1
`9e8ade`	ERROR.TYPE	`=ERROR.TYPE("a"+1)`	error-code	1
`0eebdd`	ERROR.TYPE	`=ERROR.TYPE(42)`	error-code	1
`7f40f7`	ERROR.TYPE	`=ERROR.TYPE("hello")`	error-code	1
`820ad5`	ERROR.TYPE	`=ERROR.TYPE(INDIRECT("ZZZZ99999999"))`	error-code	2
`c577e6`	CELL	`=CELL("address", A1)`	value	1
`4dc400`	CELL	`=CELL("contents", A1)`	value	1
`a9f4c2`	CELL	`=CELL("row", B3)`	value	1
`9d3b0b`	CELL	`=CELL("col", B3)`	value	1
`83de01`	CELL	`=CELL("type", A1)`	value	1
`cbfd57`	CELL	`=CELL("format", A1)`	format
`00a717`	SHEETS	`=SHEETS()`	value
`13536b`	SHEETS	`=SHEETS(A1)`	value