rand-returns-number |
RAND |
=ISNUMBER(RAND()) |
value |
|
rand-ge-zero |
RAND |
=RAND()>=0 |
value |
|
rand-lt-one |
RAND |
=RAND()<1 |
value |
|
rand-in-array-context-returns-array |
RAND |
=ISNUMBER(RAND()+SEQUENCE(3)) |
value |
1 |
randbetween-returns-integer |
RANDBETWEEN |
=INT(RANDBETWEEN(1,10))=RANDBETWEEN(1,10) |
volatile |
|
randbetween-bounds-low |
RANDBETWEEN |
=RANDBETWEEN(5,5) |
volatile |
|
randbetween-reversed-bounds |
RANDBETWEEN |
=RANDBETWEEN(10,1) |
volatile |
1 |
randbetween-negative-range |
RANDBETWEEN |
=AND(RANDBETWEEN(-10,-5)>=-10, RANDBETWEEN(-10,-5)<=-5) |
value |
|
randarray-2x3-shape |
RANDARRAY |
=ROWS(RANDARRAY(2,3))&"x"&COLUMNS(RANDARRAY(2,3)) |
value |
1 |
randarray-integer-mode |
RANDARRAY |
=RANDARRAY(1, 3, 1, 10, TRUE) |
volatile |
|
now-returns-number |
NOW |
=ISNUMBER(NOW()) |
value |
1 |
now-gt-zero |
NOW |
=NOW()>0 |
value |
|
today-returns-number |
TODAY |
=ISNUMBER(TODAY()) |
value |
1 |
today-gt-zero |
TODAY |
=TODAY()>0 |
value |
|
now-ge-today |
NOW |
=NOW()>=TODAY() |
value |
|
today-equals-int-of-now |
NOW |
=TODAY()=INT(NOW()) |
value |
1 |
row-of-target-cell |
ROW |
=ROW() |
value |
|
column-of-target-cell |
COLUMN |
=COLUMN() |
value |
|
row-of-explicit-ref |
ROW |
=ROW(A5) |
value |
|
column-of-explicit-ref |
COLUMN |
=COLUMN(C1) |
value |
|
row-over-range-returns-array |
ROW |
=ROW(A1:A3) |
value |
2 |
column-over-range-returns-array |
COLUMN |
=COLUMN(A1:C1) |
value |
2 |