assay
test suite

broadcasting

66 tests · 7 with documented divergences

Test Subject Formula Category DVs
c17f01 ADD =1+{10,20,30} value
ac487a ADD =1+{10;20;30} value
b3de1c ADD =1+{10,20;30,40} value
a750b4 ADD ={1,2,3}+{10;20;30} value
634f17 ADD ={1;2;3}+{10,20,30} value
a84536 ADD ={1,2,3}+{10,20,30} value
62a5bc ADD ={1;2;3}+{10;20;30} value
2d37b1 ADD ={1,2;3,4}+{10,20;30,40} shape
a88b06 ADD ={1,2,3}+{10,20,30;40,50,60} value
b5fb86 ADD ={1;2}+{10,20,30;40,50,60} value
d94241 ADD ={1,2,3}+{10,20} value
e95c0e ADD ={1;2;3}+{10;20} value
185cc3 ADD ={1,2;3,4}+{1,2,3;4,5,6} shape
0ff4aa MINUS ={10,20,30}-1 value
158978 MINUS ={10;20;30}-{1,2,3} value
27934a MULTIPLY =3*{1,2,3} value
897498 MULTIPLY ={1,2,3}*{1;2;3} value
6e5fe9 DIVIDE ={10,20,30}/10 value
41c0de DIVIDE =60/{1,2,3} value
acbc7f POW ={1,2,3}^2 value
3f069e POW =2^{0,1,2,3} value
68f547 op:unary- =-{1,-2,3} value
244a23 op:unary- =-{1,2;3,4} value
a47704 op:% ={50,100,200}% value
ad8163 op:= ={1,2,3}=2 value
5c0407 op:< ={1,2,3}<2 value
d9a920 op:>= ={1,2,3}>={2,2,2} value
9ff297 op:<> ={1,2,3}<>{1;2;3} value
8767d5 op:> ={1,2;3,4}>2 value
dacec0 op:& ="x"&{"a","b","c"} value
4d9a1d op:& ={"a","b"}&{"1";"2";"3"} value
3e91f8 op:& ="v"&{1,2,3} value 1
49a841 op:+ =A1:A3+C1:E1 value
ac01e0 op:* =A1:A3*10 value
4bb44b op:* =A1:A2*B1:B2 value
00df5b LEN =LEN({"a","bb","ccc"}) value 1
1d6a92 UPPER =UPPER({"a";"bc";"def"}) value
ee0cdb ABS =ABS({-1, 2, -3}) value
01f2eb SQRT =SQRT({1, 4, 9, 16}) value
f668a6 ISNUMBER =ISNUMBER({1,"a",TRUE,3}) value
66e1ce IF =IF({TRUE,FALSE,TRUE}, 1, 2) value
daa5b2 IF =IF({TRUE,FALSE,TRUE}, {10,20,30}, {-1,-2,-3}) value
bbd8ab IF =IF(TRUE, {1,2,3}, {10,20,30}) value
5a57b2 op:+ ={1,2,3}+{10,#N/A,30} error-code
12e620 op:+ =1+#DIV/0! error-code
87f114 op:/ =10/{1,0,2} value
1d08f9 op:+ =A1:A2+B1:B2 error-code
fb4315 op:+ =A1:A3+10 value
a610ec op:+ ={1,,3}+10 value
19510d op:& =A1:A3&"!" value
2592f5 op:+ ={TRUE,FALSE,TRUE}+0 value
91826d op:+ ={"1","2","3"}+0 value
eeee4a op:+ ={1,"a",TRUE}+0 value
177a4b lit:array ={1,2;3} value
c87444 op:+ ={1,2;3}+10 value 2
d5e9ce op:@ =@A1:A3+1 value
054849 feature:implicit-intersection =A1:A3+1 value
a98778 LEN =LEN({"a","bb","ccc"}) value
a85a9a feature:implicit-intersection =A1:A3 value
b3ef6f LEN =LEN(B1:B3)*1 value
2143d9 SINGLE =SINGLE({10,20,30}) value 2
2a69ac INDEX =INDEX(A1:A3*10) value
a01ba0 INDEX =INDEX({1,2,3}+{10;20;30}) value
93d57f SUMPRODUCT =SUMPRODUCT(--({1,2,3}>1)) value 3
1114fe SUMPRODUCT =SUMPRODUCT(A1:A3, B1:B3) value 2
f777d1 SUMPRODUCT =SUMPRODUCT((A1:A3>1)*B1:B3) value 2