assay
test suite

divergences

8 tests · 5 with documented divergences

Test Subject Formula Category DVs
concat-vs-concatenate-arity CONCAT =CONCAT("a", "b", "c") value 2
array-literal-semicolons lit:array ={1;2;3} value
lambda-named-function-inline-cost LAMBDA =LAMBDA(x, x+1)(5) value
hstack-with-error-value HSTACK =HSTACK(A1, 1/0) error-code 1
switch-3-arg-form SWITCH =SWITCH(1, 1, "yes") value 1
switch-4-arg-with-no-match SWITCH =SWITCH(99, 1, "one", "default") value 1
empty-string-vs-zero-comparison op:= =0="" value
true-1 TRUE =TRUE+1 value 1