assay
test suite

volatile

22 tests · 8 with documented divergences

Test Subject Formula Category DVs
1a2123 RAND =ISNUMBER(RAND()) value
d354fe RAND =RAND()>=0 value
1f57f7 RAND =RAND()<1 value
b7a27f RAND =ISNUMBER(RAND()+SEQUENCE(3)) value 1
e73efc RANDBETWEEN =INT(RANDBETWEEN(1,10))=RANDBETWEEN(1,10) volatile
6de515 RANDBETWEEN =RANDBETWEEN(5,5) volatile
8c4507 RANDBETWEEN =RANDBETWEEN(10,1) volatile 1
451012 RANDBETWEEN =AND(RANDBETWEEN(-10,-5)>=-10, RANDBETWEEN(-10,-5)<=-5) value
0ca12a RANDARRAY =ROWS(RANDARRAY(2,3))&"x"&COLUMNS(RANDARRAY(2,3)) value 1
372322 RANDARRAY =RANDARRAY(1, 3, 1, 10, TRUE) volatile
fa329e NOW =ISNUMBER(NOW()) value 1
73b792 NOW =NOW()>0 value
d51b3a TODAY =ISNUMBER(TODAY()) value 1
498a79 TODAY =TODAY()>0 value
c0de01 NOW =NOW()>=TODAY() value
4a1fbe NOW =TODAY()=INT(NOW()) value 1
eb4173 ROW =ROW() value
935bd8 COLUMN =COLUMN() value
80becc ROW =ROW(A5) value
a0e1a2 COLUMN =COLUMN(C1) value
3cdbe4 ROW =ROW(A1:A3) value 2
a82317 COLUMN =COLUMN(A1:C1) value 2